alessiobdr
New Member
- Joined
- Nov 12, 2009
- Messages
- 9
Hi all, it's me again.. new in the forum and already 2nd thread..
but i did not found anything.
I do have a excel spreadsheet with data coming in with DDE link (from data provider) like a price change of a share. Behind that spreadsheet I have macros coded in VBA.
I have to run a macro, every time a specific cell changes on the spreadsheet (price change in share).
There is the "Worksheet calculate or change" sub but it does not work with external link, like DDE. It works when you do a change manually in the workbook.
I have been looking for 3 days now, to get a proper solution, for automatically calling macros when a cell changes (price change) based on a DDE feed.
It really would make my week end much easier, to have a solution, so that I can move on with my coding.
Thanks to all for any help and have a nice week end!
but i did not found anything.
I do have a excel spreadsheet with data coming in with DDE link (from data provider) like a price change of a share. Behind that spreadsheet I have macros coded in VBA.
I have to run a macro, every time a specific cell changes on the spreadsheet (price change in share).
There is the "Worksheet calculate or change" sub but it does not work with external link, like DDE. It works when you do a change manually in the workbook.
I have been looking for 3 days now, to get a proper solution, for automatically calling macros when a cell changes (price change) based on a DDE feed.
It really would make my week end much easier, to have a solution, so that I can move on with my coding.
Thanks to all for any help and have a nice week end!
