I want a help Please

  • Thread starter Thread starter g3aau
  • Start date Start date
G

g3aau

Could any body help me to do the follwing:

I have Excel Sheet linked to another software by DDE method , so when
data is changed in the main software it dynamicaly well be changed in
my excel sheet. I want to store the data in excel sheet in a new
records each time it updated. I want to make a hestorical reference.

Thank you,
 
look in Excel VBA help at the setlinkondata property. You can assign a
macro to this link using that - then have the macro record the value. The
macro will fire when the cell is updated.

--
Regards,
Tom Ogilvy


g3aau said:
Could any body help me to do the follwing:

I have Excel Sheet linked to another software by DDE method , so when
data is changed in the main software it dynamicaly well be changed in
my excel sheet. I want to store the data in excel sheet in a new
records each time it updated. I want to make a hestorical reference.

Thank you,


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top