Help - Search - Members - Calendar
Full Version: Gateway
Forums.MrPLC.com > PLCs and Supporting Devices > Allen Bradley
Brad
How do I poke a DDE link through Linx Gateway using a remote PC with Excel.
HalBishop
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
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
got it! It was in the snytax!! Thank-you!!
HalBishop
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.
Invision Power Board © 2001-2010 Invision Power Services, Inc.