SLC5/04 & Excel Query

Translate This Thread From English to

Threaded View
BIGEYE's Avatar (by Gravatar)BIGEYE posted on
November 15, 2005, 3:49 pm
rate this thread


A number of years ago I wrote a Lotus 123 spreadsheet (with some help), that
monitored in real time, analogue inputs to a Modicon 984 PLC.
Each cell was set up as a Datalink  Link, for example
@DATALINK("view","tagname","tonnerate").
Is it possible to do this with an Allen Bradley SLC5/04 PLC and Excel?
TIA



Other Related Threads
BIGEYE's Avatar (by Gravatar)BIGEYE posted on
November 15, 2005, 3:51 pm
Permalink

Re: SLC5/04 & Excel Query




Another cell formula we used was
@DATALINK("modbus","plc1","41120")



Other Related Threads
A. Paul Montgomery's Avatar (by Gravatar)A. Paul Montgomery posted on
November 15, 2005, 10:18 pm
Permalink

Re: SLC5/04 & Excel Query



[invalid].ok says...

Yes. I do not know what exactly the command is. It would depend on which
ODBC drivers you have loaded. Both Labview and Wonderware have knowledge
databases which describe in detail the commands necessary for the SLC
family. I'm assuming that your question was more towards what the
command actually is tho. Maybe someone here will know this off hand.
--
Paul Montgomery
Progressive Gauging Inc.

Mark@AST's Avatar (by Gravatar)Mark@AST posted on
November 16, 2005, 11:24 am
Permalink

Re: SLC5/04 & Excel Query



Check out www.automatedsolutions.com for a Serial DF1 or DH+ ActiveX
Control compatible with SLC5/04 that can be embedded in your Excel
spreadsheet.

You will need to implement a very small amount of VBA code.


Site Timeline