81
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
1)
Open SCADA project
Summary of Contents for VR06
Page 1: ...User Manual Paperless Recorder VR06 UMVR061D Brainchild Electronic Co Ltd 4th Edition 10 2013 ...
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 69: ...69 Make sure that RS 232 communication setting at the recorder and PC are equal ...
Page 86: ...86 7 Trouble shooting ...
Page 87: ...87 ...
Page 88: ...88 ...