I wonder if someone has some examples they might be willing to share of Excel spreadsheets that write data to Clx PLCs via RSLinx OPC.

I need to occasionally load some lookup tables in the PLC with data that is in a CSV file.

 

I think using DDE in Excel for anything but a technical user playing around or troubleshooting is a bad idea for many reasons. However, there are several similar downloadable examples, none of which I've used myself. As far as I know, the only difference with a Control Logix PLC for a basic OPC/DDE request should be the tag address.

http://forums.mrplc.com/index.php?download=741
http://forums.mrplc.com/index.php?download=743
http://forums.mrplc.com/index.php?download=543

----
Nathan Boeger
http://inductiveautomation.com
http://notanotherindustrialblog.blogger.com

 

I agree with Nathan and I suggest you develop an application as a bridge between Excel and OPC.
You can use VB.net or C#.

For sample on how to connect and read/write to OPC using VB.Net here's a simple example:
http://www.faweb.net/us/opc/sample_vbnet.html

For sample on how to connect to Excel and read data using VB.Net or C#, you will find a lot of links through google.

You just need to combine above 2 samples to read from excel and write to OPC and build whatever logic you may need to build.

Please contact for further assistance.

Vipul Shah
http://www.egenietech.com
[email protected]