Brainchild VR06 - DDE Configuration for SCADA

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