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 |
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 |
All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com