View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how to capture data

you can tie a macro to the DDE link using the SetLinkOnData command.

In xl2000 and later, the Change event also fires when a DDE link is updated.

--
Regards,
Tom Ogilvy

"Alberto Brivio" wrote in message
...
Dear All,

I have a worksheet excel composed of dde links.

I would like to know how can I do to store in a db / file data changing by
DDE.



Regards

Alberto Brivio