I have had experience with reading DDE data from RSLinx into excel but I have been asked by a client to generate a sheet with multiple tabs that can reside on a server and allow multiple users to navigate the same sheet.
The problem I am having is understanding how RSLinx would work in this senario. Can all copies of the same sheet access RSLinx data through one instance of RSLinx or will each user need a copy of RSLinx running? My concern with multiple copies of RSLinx running is the amount of duplicate traffic to the PLC.
I am aware that a SCADA system would be better but the client does not have the budget for this.
Has anyone got any ideas they can share?
The problem I am having is understanding how RSLinx would work in this senario. Can all copies of the same sheet access RSLinx data through one instance of RSLinx or will each user need a copy of RSLinx running? My concern with multiple copies of RSLinx running is the amount of duplicate traffic to the PLC.
I am aware that a SCADA system would be better but the client does not have the budget for this.
Has anyone got any ideas they can share?