×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Using Excel with DDE to collect data

Using Excel with DDE to collect data

Using Excel with DDE to collect data

(OP)
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!

RE: Using Excel with DDE to collect data

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources