81
DDE with third party applications
Once the data is available at Excel at particular cell, then data can be exchanged with the third
party applications like PLC, SCADA, and Visual Basic etc.
If data is to be exchanged with PLC, then PLC programmer can write Visual basic macro in
Excel from the following link
Excel – Tools – macro
For the source code examples, PLC programmer may check the PLC manuals for DDE sample
macros.
It is also possible to exchange data from recorder to SCADA applications through DDE.
Example 1
DDE link between Allen-Bradley SLC 5/03 PLC and Excel
Task: Write a block of data (10 floating points) from Excel to PLC.
Name of the Excel file = Reports.XLS
Data Source: D 37 to D 46, data in total 10 cells
Target= PLC, Starting address= F8
User RSLinx to configure PLC and DDE link
DDE topic name in RSLinx= DDE_REPORTS
Sub Block_Write()
'open dde link: testsol=DDE Topic This is comment only
RSIchan = DDEInitiate("RSLinx", "DDE_REPORTS")
'write data thru channel This is comment only
DDEPoke RSIchan, "F8:2,L10", Range("[Reports.XLS]PROCESS!D37:D46")
'close dde link This is comment only
DDETerminate (RSIchan)
End Sub
Summary of Contents for WH18/06
Page 1: ...User Manual Paperless Recorder WH18 06 15th Edition 03 2008 ...
Page 17: ...17 Figure 2 6 Figure 2 7 Figure 2 8 ...
Page 19: ...19 Figure 2 10 Figure 2 11 ...
Page 25: ...25 Digital input card DI181 Figure 2 21 Analog output card AO183I AO183V Figure 2 22 ...
Page 27: ...27 Figure 2 25 Figure 2 26 ...
Page 70: ...70 Make sure that RS 232 communication setting at the recorder and PC are equal ...
Page 87: ...87 7 Trouble shooting ...
Page 88: ...88 ...
Page 89: ...89 ...
Page 90: ...90 ...