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.
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