Excel Connect to ControlLogix (DDE)

To Read tags form Control Logix PLC (Allen Bradley) used RSLinx (DDE) Follow this step.
Step 0 -> Open Excel software
Step1 -> In RSlinx software go to menu DDE/OPC-> Topic configuration




Step 2 -> create your DDE/LINK



Click on New
Then give a name to this new link : for example : emulator
Then give the path to the online PLC
Click on Apply : your DDE/OPC link have been created
Click on Done.

Step3-> Goto Menu Edit-> Copy DDE/OPC Link



Then choose your DDE/OPC Link : Emulator->Online



Choose the tag you need : for exemple Test_Tag
Then click on OK

Step 4-> Paste link in Excel
In Excel software
Choose a cell and then using the right button of your mouse click on special paste



Choose « paste with link » then click on OK