Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Update Data Table On DDE Link Change
I am trying to figure out how I can automatically update a data table every time a dde link changes. The purpose is to log stock trades as the occur in real time. The DDE Links contain Time Price Volume for a number of stocks And the goal is to place this information into a table for for analysis. I've looked everywhere, including performing a Google search of the newsgroup and can't find anything that would help me to get started and I believe my primary difficulty is that I don't know all that much about macro's, though this seems to be a fairly simple task. Any help or insight with code or a good resource and even a better wording for a search would be appreciated. TIA PMC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Update Data Table On DDE Link Change
This url should be all one line - paste it into your browser after you
reconstruct it (in notepad for example): http://groups.google.com/groups?as_q...TF-8&oe=UTF-8& as_ugroup=microsoft.public.excel.programming&lr=&h l=en Regards, Tom Ogilvy PMC wrote in message ... I am trying to figure out how I can automatically update a data table every time a dde link changes. The purpose is to log stock trades as the occur in real time. The DDE Links contain Time Price Volume for a number of stocks And the goal is to place this information into a table for for analysis. I've looked everywhere, including performing a Google search of the newsgroup and can't find anything that would help me to get started and I believe my primary difficulty is that I don't know all that much about macro's, though this seems to be a fairly simple task. Any help or insight with code or a good resource and even a better wording for a search would be appreciated. TIA PMC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External link update macro | Excel Discussion (Misc queries) | |||
Trying to link/update multiple copies of a table | Excel Discussion (Misc queries) | |||
Macro update link | Excel Worksheet Functions | |||
Change pivot table source data via macro | Excel Discussion (Misc queries) | |||
Change link in pivot table | Excel Worksheet Functions |