Micromod MOD: Extended Modbus (XModbus) OPC Server Users Guide - Manual (Page 40)

Extended Modbus OPC Server
Operation and Reference
4 - 14
4.3 Dynamic Data Entry (DDE) Type Links
The Extended Modbus 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:
=xmbopc|'C100'!OP
In this example, xmbopc is the executable filename of the OPC Server, 'C100' the name
that was given to the device in the server configuration, and OP is the name given to
holding register 40014.
Excel automatically enclosed C100 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 xmbopc application is not found, or if the device name or point name is
wrong.