DDE connection from ExcelVBA

<< Click to Display Table of Contents >>

Manual > Server Creation Guide > Interface > DDE Interface >

DDE connection from ExcelVBA

overview

This article explains examples of settings and application creation for connecting to DDE via the DDE interface of FA-Server from a unique DDE client application developed using VBA in Excel.

 

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

 

Step 1 Server settings

 

Set up tag registration.

Step 2 Basic settings for Excel VBA

 

Make the necessary definitions to make DDE connections from Excel VBA.

Step 3: Reading and writing values

 

Allows you to read and write item values at any time from EXcel VBA.

 

 

Download the sample

The creation example introduced on this page provides the following samples:

 

■ Sample creation example

 

■ Sample using arrays