Using excell to collect data from wonderware?

[LoggerHead]

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

 

[djs]

Hello;
Look into XLReporter by sytech.com

 

[emidem]

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

 

[adamabelew]

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