how to capture data

A

Alberto Brivio

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
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA 2
editing rules 1
Word 2013 merge Excel, DDE conncetion path problem 0
Help with DDE - stock feed 1
How to automate update on weekly reports spreadsheet 0
Using a dde link how do I write the data from the "live" cell to astatic cell 1
When does conditional formating fire? 1
Capture data in another non-Excel window 1

Top