

- Allen bradley .dat files reader update#
- Allen bradley .dat files reader driver#
- Allen bradley .dat files reader code#
- Allen bradley .dat files reader Pc#
If you have any comments or questions on the above please feel free to leave them by filling out the “post a comment or question” link below. I hope the above information on getting data from your A-B Programmable Controller into Microsoft Excel was helpful. If you would like to explore additional ways to connect RSLinx and Excel, including button macros to upload and download multiple cells at once, search RSLinx's help system for “EXCEL.” Step 12: From the “Paste Special” menu choose “Paste Link”Īt this point in the process you should see live data from your PLC (or PAC) in your Excel workbook. Right click on a cell and select “Paste Special.” Step 11: Open a new workbook in Microsoft Excel. In the below picture I've selected T4:0.ACC. Step 10: Browse to a PLC address or tag by expanding your new topic, then the online folder, then select a tag or element and press OK. Step 9: Still inside of RSLinx, select “Edit” from the top menu and then select “Copy DDE/OPC Link…” Step 8: Click “Done” to close the DDE/OPC Topic Configuration popup window. Step 7: Press “Apply,” and then select “Yes” on the confirmation popup.
Allen bradley .dat files reader update#
Step 6: Change the “Polled Message (mSec)” rate to the rate you would like data from the PLC to update at. Note – If you're asked if you would like to update your topic, select “Yes.” Step 5: Now click on the “Data Collection” tab. Here I've typed in “MyTopic” as the name of my new topic.

Step 4: Type in a new unique name for your new topic. Step 3: In the DDE/OPC Topic Configuration popup window find your topic on the left side highlighted in blue. Step 2: In the right pane of the RSWho window right click on your PLC and select “Configure New DDE/OPC Topic.” In the below picture you can see my setup where I've connected my laptop to an Ethernet network which also has a MicroLogix 1100 on it.
Allen bradley .dat files reader Pc#
Step 1: Connect your PC to your PLC and setup RSLinx to communicate to it.

Getting A-B PLC data into Excel using RSLinx With the above in mind, you'll need a version of RSLinx (Classic) other than the free “Lite” version for the following steps to work:
Allen bradley .dat files reader code#
It also included a license for RSLinx OEM so users could test the code they wrote.

Allen bradley .dat files reader driver#
It is used as a software driver to connect your PC to your Allen-Bradley devices.
