Read and Write Data in MS Excel, using RSLinx to and from ControlLogix

Learn how to use MS Excel VBA code to Read and Write data using RSLinx Classic to and from a Rockwell Automation ControlLogix PLC.
Students in the #Automation & #Robotics program at Madison College have to complete this lab as part of their 2yr A.S. degree.
This demonstration was completed using MS Excel 2016, Studio5000 Emulate L73 processor, RSLinx Classic and Studio5000 v30.

[Crypto_B_]

Great demo. Thank you, Peter. I don’t think many professionals in our industry realize this is possible. I’ve gotten some blank stares.

[ngel]

great video. Where can I learn about more rslogix functions to use in VBA?

[LearnSomethingHelpful]

Thanks for the video, I do have a suggestion from our findings in the past few months & speaking with Rockwell.

If you try this on Windows 10 & any version of Microsoft Office above 2016 & it no longer works...DDE is what is used & it is now disabled so moving forward any command codes should be used in a real OPC not DDE like the copy-paste method. There are a lot of other tools to use & Rockwell Automation themselves has demo excel files to read & write data.

DDE is broken after Excel 2013.

You can try to enable it but depending on what version of RSlinx you are using, it will break.

Standard in the field as of 2021 is Windows 10 MS Office 2016 or even MS office 365

[mattemburgh]

Hello! How can I set this up so it logs the data every 24 hours automatically, without using a push button?

[flavioscarazzato]

Can you share the excel file used in this video?

[jorgelopez-ddgb]

It's possible do the same with Micrologix PLC??

[sergiofranciscomayoralcruz]

Can i use this funcion if i have a Micro820 and a ML1200?

[AfroMan]

Any way to export a data file to a PC that doesn't have RS Linx?

[ansonkiek]

rslink classis lite can？I don’t see the copy option this my classic lite please advise. I am using studio 5000

[caseymarionneaux]

Would this be possible from a web page that is ran from a local server using HTML, PHP, Javascript or some other language?

[jackdtdt]

Hi ! Peter ! Great Demo! Can you share me the Excel File in the Video?

[LeoGarCru]

Where to learn VBA to do things like this ?

[DuneKraftwerk]

Excel online...oops.. code scripts and socket io can make it works not DDE