Do you have a guide to do writes to PLC via dde?
This is what I use to write a value to my plc after I pull all the data I wanted.
Of course you will need rsLinx OEM and set up the topic for your PLC.
This is all done in the dev section of excel, I have a button that triggers this on the main page so I can trouble shoot it as needed. This generally runs every morning at 4am and is automated by a function within the application.
In this instance, the topic is F2905_Snap, and Program:MainProgram.Reset_Pointer is the tag that I am writing to.
Sub Reset_Front Snap()
RSIChan = DDEInitiate("RSLINX","F2905_Snap")
DDEPoke RSIChan, " Program:MainProgram.Reset_Pointer", [i1]
DDETerminate (RSIChan)
End Sub
The [i1] is the cell in the excel spread sheet that I chose to hold the data I wanted to write the the PLC. in this instance I have the number 1 in cell i1 and it writes a 1 to my plc bit named Reset_Pointer, this is a dint.
Hope this helps. If you need more, let me know and i'll share what worked out for me. I am no vba expert by any means.
Gad