Applies To:
  • CitectSCADA 1.00 1.01 1.10 1.11 1.20 2.00 2.01

The format for data in a Lotus 123 for Windows spreadsheet is essentially the same as for Excel 4.0. The main difference is that Excel uses cell references such as R1C1 and R2C4 whereas Lotus uses A1 and B7 etc. 

To write DDE information to a Lotus 123 spreadsheet use the following format;

DDEWrite("123W", "C:\CITECT\DATA\TEST.WK1", "A1", "1234")

If this is successful, the function will return 1234. If it fails, it will not return anything. In this case the DDEWrite is trying to send the value 1234 to a Lotus 123 spreadsheet called TEST.WK1 at cell A1. The 123W refers to the name of the Lotus EXE file, i.e. 123W.EXE.