DDE connection from a cell in Excel

<< Click to Display Table of Contents >>

Manual > Server Creation Guide > Interface > DDE Interface >

DDE connection from a cell in Excel

Connect to FA-Server as a DDE server from a cell in Excel

Here we will explain the steps to connect to a FA-Server tag from a cell in Excel using DDE.

 

The steps introduced here can be broadly divided into three parts:

 

Step 1: Prepare tags

 

Register the tag.

Step 2: Configure the interface

 

Configure the DDE interface.

Step 3 Excel Settings

 

Configure Excel.

 

 

The format of DDE specified from a Excel cell is as follows:

 

=Application name|Topic name!Tag name

 

example)

=FASERVER|U01.F01!T01

 

 

hint

You can also simplify the format definition by shortening the application name, unit name, and folder name. The application name can be changed from the DDE interface properties.

 

example)

=F|U.F!T01

 

 

 

Download the sample

The creation examples shown on this page are provided with samples.

 

The sample can be downloaded from below.