Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want a help Please
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want a help Please
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|