how can i get live changing values of the cell RRS feed

  • Question

  • hi
    im not able to get any solution but i know a solution sure exists.
    i have an excel sheet
    in which the cell A1 is getting data from a DDE server. So this cell has a formula i.e. =edemo!tik!id0. I want to access this live changing(stock quotes) data in my C# program.
    Now since there is no support
    for DDE in .NET, i m using Automation.
    Now i want to trap the sheet change event of this excel sheet in my C# program. Im using sheet_change event handler.

    But sheet change event doesnt repsond if the cell is changed due to a formula. i am succesfully able to trap this event if cell is changed manually, but not if the cell has some DDE formula.

    how can i get live
    changing values of that cell in my program using sheet_change handler?
    • Moved by nobugz Wednesday, April 22, 2009 7:11 AM not a c++ language q
    Wednesday, April 22, 2009 6:07 AM