Data from Excel to PLC

Hi guys

I know how to import the data from PLC(AB) to Excel using RSlinx, the question for you guys is how to import the data from Excel to PLC?

Thanks

Search DDE Poke, your answer is there. I learned this in a PLC class, but have since forgotten the exact code needed for this to work in Excel, would love to see it again though.

This is how I do it:

Private Sub Download_Click()
Svar = MsgBox("Ønsker du at Downloade værdier til PLC !", vbOKCancel, " Procestype 1")
If Svar = vbOK Then
RSIchan = DDEInitiate("RSLinx", "B1")
DDEPoke RSIchan, "Sekvens[1,0,0],L90,C2", Range("[B1Recepter.xls]ProcesType1!C246")
DDETerminate (RSIchan)
End If
End Sub

My data is 2-dimentional, or 3 really but the first digit is the step in the sequence.

Michal_dk

Kepware has a DDE Client driver that you can use in its OPC Server to get data from an excel spread sheet to an OPC Client and you can then write the data back down to the PLC. Use the LinkMaster product and you can read the data from the DDE Client driver and write it down to the PLC through RSLinx. The LinkMaster can be configured using drag and drop so the whole process can be completed in a few minutes.

Sorry for the sales like pitch but I think the products will solve your problem.

DDEPoke RSIchan, "Sekvens[1,0,0],L90,C2", Range("[B1Recepter.xls]ProcesType1!C246")

I am confused on what does L90 and C2 mean after tag name, please explain

L90 is the length and C2 is the "dimention"

So basically the code will transfer 90 values from Excel and take the data from two rows.

Sadly the emoji hides the true code, it should be:
ProcessType1! C2 : D46, so starting at Cell C2 and ending at Cell D46 = 90 values

Hello, I am a beginner, want to write "0" to B3:0.0 and "1" to B3:0.1, and so on, I am using Visual Basic 6.0 (Rslinx 2.41, Rslogix500, Topic:WML1500) Is it posible not to use Excel to do this kind of DDEPoke? could someone write the vba syntax and an example ??? Thank you.

You can use https://integrationobjects.com/opc-products/opc-data-archiving/opc-easy-archiver/ to export the data to excel