Worksheet change event trapping in Excel

V

vivekthakur

hi

i have an excel sheet in which the cell A1 is getting data from a DD
server. So this cell has a formula i.e. =edemo!tik!id0. I want t
access this live changing data in my C# or VB program.

Now i want to trap the sheet change event of this excel sheet in m
C#orVB program. Im using sheet_change event handler.

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

how can i get live changing values of that cell in my program usin
sheet_change handler? or is there any other way?

Vive
 
Top