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" wrote in message
...

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,


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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