17. September 2015 | 20 Comments How to read values from ControlLogix L61 directly in Excel what you need AdvancedHmi Driver Rockwell (Allen-Bradley) PLC (I use L61) with EthernetIP Modul excel (I use office 2010) You can download a excel file with other needed files ready to use, EthernetIP_Excel_Communication.zip this method is simple and free to use, it is compatible with other Rockwell Allen Bradley PLC’s such as ControlLogix L61, or CompactLogix L32-ER,L35.
“ActiveX component can’t create object” error message when I using this lib “EipCommClient.setPlcIPAddress (ipaddr)” Reply
Hello, This works great for most of what I am looking to do. I need to read/write a lot of strings from multiple processors and this had no problems in executing the reads. The great part is that it works without having to buy an expensive OEM license. Is it possible to perform a ‘write’ function as well? I see where the data is passed to perform the ‘read’ and assume there is a similar command for a ‘write’ EipCommClient.setPlcIPAddress EipCommClient.setPlcSlot EipCommClient.GetData EipCommClient.Close Is there a “EipCommClient.SetData” or something to that effect? Do you have a description of these? On a side note, I noticed that I can read Temp_DINT.1 without issue but I get an error for the same DINT if trying to read Temp_DINT.0 Thanks for the awesome solution! Reply
in this version of library is no possibility to write data, so it means, that I have to program it, but currently I dont have time to do this. Reply
Do you foresee a time in the future you would be interested in doing this? I would gladly contribute financially. Reply
Also, I am not in a situation where I can test at the moment, but is there a different syntax for accessing program level tags vs controller level tags? Reply
Yes, there is some difference, if you need to access ProgramTags, you must set the Path, it loocks like [ProgramName]Tagname. Reply
Hi, I am experiencing same issue as liu, above. Using Excel 2010 64-bit on Windows 7 64-bit, and get Error 429, “ActiveX component cannot create object.” Any suggestions? Reply
It does not read value of string tags in Excel. Only reads the length of the string tags. Can you lease advise how can read string tags. Thanks Reply
Hi, Your work was really good ! I create a program in C# and want to add Ethernet/IP for Rockwell. How did you develop your communication protocol ? Reply
How do I change the “read data” command button to call for the data from the PLC when a cycle completes? Thank you, this helped out a lot. Reply
Hello, excellent driver. How can I test for good communication, so I can have a good read and if the communication fails, create an alarm or do a retry using an excel macro. Any advice would be appreciate. Thanks Reply
This tool Works great, But i am having a problem with 1 IP Address. whenever I try to get tag values from 10.10.9.67 the macro stops with the message “Index was outside the bounds of the array” Is there something I’m doing wrong here? Reply
I found that you can only use this tool for 11 different IP Addresses before you need to close it and restart it. Otherwise when you try a 12 address it will stop the macro with “Index was outside the bounds of the array”. Is there a way to clear temp memory in VBA to allow you to scan more IP addresses without having to close the project and reopen? Reply