Team,
I am a plc guy that has been tasked with making an automated report with excel. I have been successful with everything (with lots of searching on this forum) except writing a value back to the PLC.
The sample code structure given in RSlinx OEM help is as follows:
Sub Word_Write()
RSIchan = DDEInitiate("RSLinx", "testsol")
DDEPoke RSIchan, "N7:30", Range("[RSLINXXL.XLS]DDE_Sheet!D7")
DDETerminate (RSIchan)
End Sub
I removed the comments to reduce space.
My first issue is ddeInitiate. When I process this line, I get an error that RSLinx.exe is missing or inaccessible.
I don't need to start RSLinx OEM as it is already running.
What I want to do is to move a value from active sheet [I1] into
"=RSLINX|F2905_Snap!'Program:MainProgram.Index_Pointer'"
This link works, as I am using this value to tell my application how many rows to populate.
Index Pointer is a DINT data type.
I am probably over thinking this and causing my own troubles. Any advice will be appreciated.
Gad
I am a plc guy that has been tasked with making an automated report with excel. I have been successful with everything (with lots of searching on this forum) except writing a value back to the PLC.
The sample code structure given in RSlinx OEM help is as follows:
Sub Word_Write()
RSIchan = DDEInitiate("RSLinx", "testsol")
DDEPoke RSIchan, "N7:30", Range("[RSLINXXL.XLS]DDE_Sheet!D7")
DDETerminate (RSIchan)
End Sub
I removed the comments to reduce space.
My first issue is ddeInitiate. When I process this line, I get an error that RSLinx.exe is missing or inaccessible.
I don't need to start RSLinx OEM as it is already running.
What I want to do is to move a value from active sheet [I1] into
"=RSLINX|F2905_Snap!'Program:MainProgram.Index_Pointer'"
This link works, as I am using this value to tell my application how many rows to populate.
Index Pointer is a DINT data type.
I am probably over thinking this and causing my own troubles. Any advice will be appreciated.
Gad