RSLinx

Hi all

I want to monitor/Recieve PLC tag in excel through Rslinx.
can anybody help me?

Hi,

You will need a minimum of RSLinx single Node (basically anything but Lite). If you check RSLinx Help files, you will find several topics covering this very subject, with several examples.

I'm pretty sure there will be several examples/threads on here if you do a search...


Hope this helps.

Rob

I´ve been using XLReporter for more than 6 years with no problem, you can try for free at www.sytech.com, you have to use rslinx classic as an OPC server.

Here is one link which should help you.

http://www.plcdev.com/connecting_controllogix_excel

I have been told that starting after Microsoft office 2003, Excel no longer supports OPC connections. Haven't tested this myself yet, but this will be an issue for me before too long. I am looking at other solutions... any one have any great ideas??

MNMark said:

I have been told that starting after Microsoft office 2003, Excel no longer supports OPC connections. Haven't tested this myself yet, but this will be an issue for me before too long. I am looking at other solutions... any one have any great ideas??

Click to expand...

Recently, I have installed XLReporter with excel 2007 with no problem.

Have you tried Excel Reporter? it's an easy and fast way to log your RSLinx data into excel. I used it many time.

As Kidblue mentioned, you will need a version of RSLinx that supports OPC data links. RSLinx Classic for example. RSLinx Lite doesn't support DDE/OPC data exchange.

Before you can access the data you will need to set up a topic for the data exchange in RSLinx. This is done under the DDE/OPC>Topic Configuration menu option. Create a topic name and point it to the AB PLC you want to access. Point it to the processor if you are using RSLogix5000 series PLC.

If the processor is not listed you will need to add it to your list of configured drivers.

Once that's done you can the use the menu item Edit>Copy DDE/OPC Link to select the item you're after. Browse the tree until you find the item you want to get data from, click on it and then click OK. This will copy the link to the clipboard.

In Excel select a cell and right click on it. Select Paste Special and then select Paste Link. You should see the data displayed in the cell.

Hope this helps. And please let us know how you made out.

Dave