Using Excel with DDE to collect data

[SilverLoop]

I was wondering if anyone could me started on using Excel and DDE to collect data, plot it, and then archive some of the data. I know this is a broad subject and I will be getting some specifications at a later point but I am new to this application of Excel and am trying to shorten the learning curve. Is it necessary to purchase a third-party product to do these things with Excel or can it just be done with VBA and/or DDE scripting?

Thank you!

 

[electricpete]

I am by no means an excel or DDE wizard but I was able to successfuly use this feature at work. We had DDE built into excel to connect to some of our network databases. To get started I went to the database menu and opened up the database from there. Don't remember exactly what happened after that but it was pretty straightforward.

Hopefully someone else can give more details or better info.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.