Applies To:
  • CitectSCADA - Discovered in V7, although applicable to previous versions
Summary:

When attempting to use DDE to communicate between CitectSCADA and Excel (German edition) the call to the DDE Cicode functions eg DDERead do not return the data expected. Null/empty value(s) returned.

 

Solution:

Rows and columns within an Excel spreadsheet are referenced as a parameter in the DDE functions. For example:

DDERead("Excel","Sheet1","R1C1")

In the German edition of Excel, rows and columns are referred to as Zeile and Spalte

Change the DDERead call to be in the following form:

DDERead("Excel","Sheet1","Z1S1")

 
Keywords:
 

Attachments