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
Содержание WH18/06
Страница 1: ...User Manual Paperless Recorder WH18 06 15th Edition 03 2008 ...
Страница 17: ...17 Figure 2 6 Figure 2 7 Figure 2 8 ...
Страница 19: ...19 Figure 2 10 Figure 2 11 ...
Страница 25: ...25 Digital input card DI181 Figure 2 21 Analog output card AO183I AO183V Figure 2 22 ...
Страница 26: ...26 24 VDC auxiliary power supply card AP181 Figure 2 23 2 5 RS 232 RS 422 RS 485 wiring Figure 2 24 ...
Страница 27: ...27 Figure 2 25 Figure 2 26 ...
Страница 70: ...70 Make sure that RS 232 communication setting at the recorder and PC are equal ...
Страница 87: ...87 7 Trouble shooting ...
Страница 88: ...88 ...
Страница 89: ...89 ...
Страница 90: ...90 ...