RSLinx

hamm3r1 · Apr 30, 2020

Is it possible to run OPC to excel using RSlinx professional?

OkiePC · Apr 30, 2020

Yes, the Professional, OEM and Gateway licenses support OPC.

Operaghost · Apr 30, 2020

Yes.

In RSLinx you can right-click on a CPU and select an option to create an OPC Topic. Or go to the DDE/OPC menu and create the topic. Note that you don't specify the data at this point.

Once you configure the topic you can go the the Edit menu to copy the OPC/DDE link and it will ask you for the specific data. Then in Excel if I recall you do a Paste Special and then select Paste Link.

OG

widelto · Apr 30, 2020

Yes, We use XLReporter from www.sytech.com
We generate lots of automated reports, OPC client is located inside Excel and opc server is our rslinx professional.
I have also used OPCExpert from www.opcti.com to collect data from RSLinx opc server toward excel.
I do not work for sytech nor opcti.

hamm3r1 · Apr 30, 2020

Thanks for the info. I have not had much luck with this since I got back from my deployment and my laptop updated, I kept getting an error in excel.It worked before then. So I'll see how it goes with your info.

hamm3r1 · May 5, 2020

I created my DDE/OPC topic, copied and pasted special in excel and get #REF! error.
=RSLINX|Valve_test_12!'Fill_Delay.ACC,L1,C1' this is the code its looking at.

widelto · May 5, 2020

This is a good tutorial:
http://www.plcdev.com/connecting_controllogix_excel

Operaghost · May 5, 2020

And screenshots of what you setup in RSLinx would help

OG

RSLinx

hamm3r1

Member

OkiePC

Lifetime Supporting Member

Operaghost

Member

widelto

Member

hamm3r1

Member

hamm3r1

Member

widelto

Member

Operaghost

Member

Similar Topics