In Today's article I'll walk you through how you can bring Allen-Bradley Programmable Controller Data into Microsoft Excel 2016 using RSLinx Classic.
NOTE: The below procedure works with any licensed copy of RSLinx Classic, including Single Node, OEM, and Gateway shown below. However, it will not work with the free “Lite” version.
Step 9) And click on OK when done:
To watch a video demonstration of the above, check out Episode 41 of The Automation Minute Season 4 below:
If you found this article helpful, please share it with your colleagues on LinkedIn, Facebook, Twitter or Goggle Plus!
And if you know anyone who would benefit from Allen-Bradley PLC, HMI, or SCADA training, please let them know about my affordable courses over at TheAutomation School.
You can also share your own thoughts and opinions on this subject by clicking on the “post a comment or question” link below.
Enjoy the benifits of membership! Insider news, rewards, & more: Patreon.com/automation
If you enjoyed my article, you may like my courses at TheAutomationSchool.com
Have a question on this topic? Click here to scroll down to the comment link
Have a news tip? Share it with us here
Latest posts by Shawn Tierney (see all)
- ControlLogix Reading Data From CompactLogix, SLC-500, MicroLogix over Ethernet (Video S29) - January 16, 2020
- First Mitsubishi FX-5 PLC Program using GX Works 3 (Video S28B) - January 12, 2020
- Mitsubishi FX-5 PLC Unboxing, GX Works 3 Download, Installation (Video S28A) - January 12, 2020
Click HERE to scroll down to view or leave comments
- Does this procedure allow you to store data or is it real time only?
My client wants to perform 5 task, storing 3 data points for each task and the once a week download the spreadsheet.
Is this possible@BB32152,
I'll let the article and video speak for themselves 🙂
If you decide you don't want to write Excel VBA code to automate data collection, there are lots of products out there that will do this for you, plus you can also write PLC code to store data in the PLC and then use a button in Excel to read that stored data into Excel.
Best of luck,
Instructor at The Automation School