Category Archives: Automation

Excel VBA: RsLinx DDE example

'Initialize DDE
channelNumber = Application.DDEInitiate("RSLinx", "SomeTopicName")

'Read from PLC5
readValue = DDERequest(channelNumber, "N20:1")
'Read from ControlLogix
readValue = DDERequest(channelNumber, "ControlLogixTag[1]")

'Write to PLC
Set rangeToPoke = Worksheet("Sheet1").Range("A1")

'Write to PLC5
Application.DDEPoke channelNumber, "N20:2", rangeToPoke
'Write to ControlLogix
Application.DDEPoke channelNumber, "ControlLogixTag[1]", rangeToPoke

'End DDE
Application.DDETerminate channelNumber

iFix

Known Names & Versions

  • Intellution FIX32 v6.15
  • Intellution FIX32 v7.0
  • Intellution iFix 2.21
  • Intellution iFix 2.5/2.6
  • Intellution iFix 3.0
  • GE FANUC iFix 3.5
  • GE FANUC iFix 4.5
  • GE Intelligent Platforms Proficy HMI/SCADA iFix 5.0
  • GE Intelligent Platforms Proficy HMI/SCADA iFix 5.1
  • GE Intelligent Platforms Proficy HMI/SCADA iFix 5.5

External Links: