Filter
Top Products
D
D-5GFK-080B4 Appendix D Communications Using Windows DDE
Viewing PLC Data in another DDE-compliant Application
You can view the PLC data in another DDE-compliant application by copying the data
link to the Window’s clipboard and then pasting the link into the application.
To copy the link to the clipboard, from the “Options/Driver Messages” screen select the
desired link in the “Topic/Item List” by clicking on it and then clicking the Copy button.
To paste the link in another application, switch to the other application and paste the
link (this is typically done with the “Paste Special” or “Paste Link” option from the “Edit”
selection on the menu bar, but the exact procedure may vary depending on the
application).
Writing Values to the PLC from another Application
To write data to a PLC address, the client DDE application must POKE the desired value
to the server link that represents the address. Note: in this demonstration software, the
only topic that is supported is “CPUID” and the only items supported are the following:
“R,1”, “R,2”, “I,1”, “O,1”.
The following Microsoft Excel macro (in cells A1 through A4) writes the value in cell B1
to register 1.
cell A1 – INITIATE(”MICROWIN”,”CPUID”)
cell A2 – POKE(A1,”R,1”,B1) cell A3 – TERMINATE(A1)
cell A4 – RETURN()
cell B1 – Data for Register 1
This specific macro would execute the following steps:
1. The “INITIATE” function opens a DDE channel to Server “MICROWIN” and Topic
“CPUID”.
2. The “POKE” function writes the data value in spreadsheet cell B1 to register 1
(”R,1”).
3. The “TERMINATE” function closes the DDE channel that was opened in cell A1.
4. The “RETURN” function ends the macro.
Ordering Information
For information about ordering this product, and for technical support, contact:
Engineering Specialists Inc.
12805 W. Burleigh Rd.
Brookfield, WI 53005–3119
414–782–3050