beautypg.com

Dynamic data entry (dde) type links, 2 dynamic data entry (dde) type links – Micromod MOD: ICN OPC Server Users Guide User Manual

Page 35

background image

ICN OPC Server

Operation and Reference

4.2 Dynamic Data Entry (DDE) Type Links

The ICN OPC Server supports DDE (Dynamic Data Exchange) for serving data to DDE
Client applications such as Microsoft Excel.

The typical reference for DDE connections is:

Program|Topic!Point

The character between Program and Topic is called a Pipe, the dashed vertical line
character on the keyboard. An exclamation point is used between the Topic and Point.

Refer your application's documentation for using DDE. The following example is for
Microsoft Excel:

=icnopc|’mod30ml’!LICOP

In this example, icnopc is the executable filename of the OPC Server, mod30ml the name
that was given to the device in the server configuration, and LICOP is the name given to
the tag.

Excel automatically enclosed mod30ml in quotes. The rule is that if a Topic or Name
contains spaces or special characters, it must be enclosed in quotes.

After entering the valid reference, Excel asks to start the application if it is not already
running.

The #REF! Error value occurs when a cell reference is not valid. In this example, this will
occur if the icnopc application is not found, or if the device name or point name is wrong.

4 - 9