82
Example 2
DDE link between Allen-Bradley SLC 5/03 PLC and Excel
Task: Read a block of data (5 integers) from PLC to Excel
Name of the Excel file = Reports.XLS
Data Source: PLC, Starting address= N7:30
Target cells in Excel= A7 to A11
User RSLinx to configure PLC and DDE link
DDE topic name in RSLinx= DDE_REPORTS
Sub Block_Read()
'open dde link: testsol=DDE Topic This is comment only
RSIchan = DDEInitiate("RSLinx", "DDE_REPORTS")
'get data and store in data variable This is comment only
data = DDERequest(RSIchan, "N7:30,L5,C1")
'Paste data into selected range This is comment only
Range("[Reports.XLS]DDE_Sheet!A7:A11").Value = data
'close dde link This is comment only
DDETerminate (RSIchan)
End Sub
Example 3
DDE between Observer software and SCADA (Allen-Bradley RSVIEW32)
When the Real time viewer in Observer II is working well in PC, then the tag data from Observer
software will be available in the expression format as follows
=RealTime_Viewer|TagService!_AI1
Application = RealTime_Viewer
Topic = TagService
Tag name = _AI1 (Please observe underscore before the name of the tag)
The above tag information can be directly configured in SCADA to enable DDE between
Observer software and RSVIEW 32 SCADA. There is no need to configure any thing at RSLinx.
Procedure for configuration
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 ...