Hi Stu
I am running a licensed version of RSLinx Classic and Excel 2007.
Cherrs
Ok, you are in good shape then. The first thing that you need to do is create a DDE/OPC Topic for the PLC you want to gather data from. Open RSLinx, and click on DDE/OPC on the Menu Bar, then select the first choice on the Drop Down "Topic Configuration". It will bring up a Browse Window, drill down to the PLC you want to gather data from, and select that. I am at home, so I am doing this from memory, but I think you have to Right Click the PLC, and look for something like New Topic.
That is far as I can take you right now. I should have asked you what version of RSLinx you are using. I think the newer versions will allow you to monitor the PLC Data Tables, and allow you to select them and do a copy and paste into Excel. I can do a better job on Monday, where I have a PLC to actually do the steps on. There is a way to get RSLinx to create the Path for you, but I can't remember the sequence of steps. It is getting late here, and the old memory isn't what it used to be.
In the mean time, the RSLinx Help might give you some clues. A search here will probably find some examples, if you are in support as AB says, you can search their Knowledgebase, and last but not least Google it.
Stu....