Excel can't find RSLinx

[KKWKKW]

Hi all!

1st post, thanks for being here!

Rockwell Automation's RSLinx is a DDE interface. It provides connection to a PLC (Programable Logic Controller).
Using Excel as the DDE data source is not the issue.

In VBA, here is the offending line of code:

Please Login or Register  to view this content.

When this line is encountered, Ecxel responds with a window stating:
Remote data not accessible. .....Start application 'RSLINX.EXE'?
Selecting 'Yes' leads to:

Microsoft Visual Basic run-time error '-2147352571 (80020005)'
Cannot run 'RSLINX.EXE'. The program or one of its compoments is damaged or missing.

This spreadsheet came from another computer that also has RSLinx loaded, and this part works fine.
I have reloaded RSLinxs, and it is the same version number and flavor as the one loaded on the other computer.

So, I have to conclude that I'm probably missing some sort of global project reference to the Windows App "RSLinx".
I cannot find documentation or example code, etc. that can provide an answere and/or guidance.

Can anyone help?

Thanks!

[marioferyhwh]

I have the same problem with excel 2013 and RSLogix 3.51 not found anything yet and if you found something as

[rolled]

The problem here is that you haven't defined the topic in RSLinx. To find out what the Topic name is, type ?TopicID in the immediate window of the VBA debugger

Open RSLinx
Click on menu item DDE/OPC
Select Topic Configuration
Click the New button
Give it the correct name and point it at the right PLC
Click Apply. Confirm that you want to update the topic
Click Done

Try again

If moving from one PC to another, then you could use the RSLinx Backup / Restore tool to copy the existing configuration to your new PC