I remember reading a thread that explained how to use a remote PC running RSLinx Classic as a server to allow an Ecxel spreadsheet running on another PC on the same network to read data from PLCs through the server.
I have successfully created topics on the server and can run a spreadsheet on it that shows updated values from PLCs. I just need to know how to format the link to look for the server, rather than having it try to open RSLinx on my PC.
Here's an example of what works on the server:
=RSLINX|'1_LITER_STACKER'!'N11:1,L1,C1'
I've tried things like "=\\192.168.9.92\RSLINX|'1_LITER_STACKER'!'N11:1,L1,C1'" without success.
Can someone point me in the right direction?
I have successfully created topics on the server and can run a spreadsheet on it that shows updated values from PLCs. I just need to know how to format the link to look for the server, rather than having it try to open RSLinx on my PC.
Here's an example of what works on the server:
=RSLINX|'1_LITER_STACKER'!'N11:1,L1,C1'
I've tried things like "=\\192.168.9.92\RSLINX|'1_LITER_STACKER'!'N11:1,L1,C1'" without success.
Can someone point me in the right direction?