To watch a video demonstration of the above, check out Episode 41 of The Automation Minute Season 4 below:
#Rslinx classic oem how to#
Step 17) If you'd also like to learn how to create a button to upload or download many tag values, search RSLinx Classic's Help on the word “Excel” for example macros: Step 16) This procedure works for ControlLogix, CompactLogix, PLC-5, SLC-500, and MicroLogix as shown below: Step 15) However, after a few seconds you should see you Programmable Controller's live data appear: Step 13) At first you may see “#N/A” as the data is being fetched from RSLinx: Step 10) Now in Excel, right click on the cell where you'd like the data to appear and select Paste Special: Step 8) Then browse for the address or tag whose value you'd like to display in Microsoft Excel: Step 7) Now from the Edit menu (only available in licensed versions of RSLinx Classic as noted previously,) select Copy DDE/OPC Link… Step 6) Now select Done to close the Topic Configuration window: Step 5) When prompted, select Yes to update the topic with your changes: Note that in this example I changed the Polled Message rate from 1000ms to 50ms: Step 4) When done reviewing the default settings and making any changes, click on the Apply button. Step 3) Next, select the Data Collection tab and review the default settings: In this example I name my new topic “L61”:
![rslinx classic oem rslinx classic oem](https://www.ewon.biz/images/librariesprovider10/support/rslinx-1-configure-driver.png)
Step 1) Locate the Programmable Controller you'd like to get data from in the RSLinx Classic RSWho window, then right click on it and choose, “Configure New DDE/OPC Topic” as shown below: However, it will not work with the free “Lite” version.
![rslinx classic oem rslinx classic oem](https://367he63vt2ig32zhzt329os1-wpengine.netdna-ssl.com/wp-content/uploads/2015/07/rslinx.png)
NOTE: The below procedure works with any licensed copy of RSLinx Classic, including Single Node, OEM, and Gateway shown below. 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.