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