3. Modify Point Data

You can write Excel macros to update setpoints in CIMPLICITY software from a spreadsheet. These macros will use the DDE POKE request. You can use this request to change the value or raw_value attributes of a CIMPLICITY point.

Important: Setpoint security is not enforced. A user can set any CIMPLICITY point that has write access, regardless of the setpoint security restrictions configured within the CIMPLICITY system. You must establish appropriate operational practices and procedures to prevent undesired setpoint operations, and users must follow these practices and procedures carefully.


Visual Basic Format (Microsoft Excel 97/2000).


Performance considerations.


Macro implementation.

More information

CWSERV with Microsoft Excel.