View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PMC[_2_] PMC[_2_] is offline
external usenet poster
 
Posts: 1
Default 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