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

preview_player
Показать описание
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.
Рекомендации по теме
Комментарии
Автор

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

Crypto_B_
Автор

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

ngel
Автор

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

LearnSomethingHelpful
Автор

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

mattemburgh
Автор

Can you share the excel file used in this video?

flavioscarazzato
Автор

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

jorgelopez-ddgb
Автор

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

sergiofranciscomayoralcruz
Автор

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

AfroMan
Автор

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

ansonkiek
Автор

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

caseymarionneaux
Автор

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

jackdtdt
Автор

Where to learn VBA to do things like this ?

LeoGarCru
Автор

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

DuneKraftwerk
join shbcf.ru