Brad
Sep 30 2005, 11:44 AM
How do I poke a DDE link through Linx Gateway using a remote PC with Excel.
HalBishop
Sep 30 2005, 11:54 AM
I used this to poke a value into a CLX processor from an Excel sheet.
Private Sub CommandButton1_Click()
'open dde link
RSIchan = DDEInitiate("RSLinx", "Tarmac")
'write data thru channel
DDEPoke RSIchan, "MarineReceiving.SequencerStepDescription[0].LEN,L1,C1", Range("[SequencerDescriptions.XLS]Sheet1!D1")
DDETerminate (RSIchan)
End Sub
Brad
Sep 30 2005, 12:06 PM
To clarify
I have a network computer running rslinx gateway
A network computer running excel
Iam not having a problem reading data using dde but Iam not able to do ddepoke
thru excel only reads.
Brad
Sep 30 2005, 12:26 PM
got it! It was in the snytax!! Thank-you!!
HalBishop
Sep 30 2005, 12:56 PM
That is what I both love and hate about this vocation.
When it works, this is the best thing I have ever done.
When it doesn't work, I think about calling 1-800-TRUCKMASTER.
Glad I could help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here.