×
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 excell to collect data from wonderware?

Using excell to collect data from wonderware?

Using excell to collect data from wonderware?

(OP)
Wondering if anyone uses excell to gather data from wonderware instead of using wonderware to write to excell? I have been told it can be done but have not ever seen it.
If I remember right, excell and wonderware can either one be the client or server. I'm no expert in excell by any means and have not had any luck doing this. Any direction in reguards to this would be very helpful.
Thanks,
Daymond

RE: Using excell to collect data from wonderware?

Hello;
     Look into XLReporter by sytech.com

RE: Using excell to collect data from wonderware?

Use this syntax
=view|tagname!Tag1                    if u working locally
=\\PC\view|tagname!Tag1               FOR REMOTE COLLECTION


and if it doesnt work try running  DDESHARE and declare VIEW as a trusted share with a full access to anyone !
that's all
IMAD ALLAHIA
Technicien Electricien
P&G Maroc

RE: Using excell to collect data from wonderware?

If you are using a DDE server, you can use the command in a cell of Excel: "<application of DDE>|<topic within DDE Server>!'tag name'"

for example if the DDE application is called "DDE_app"
and topic is "Topic1" and tagname is "tag1" the command in the cell would read:

=DDE_app|Topic1!'Tag1'

I hope this helps

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