Use the search and browse feature to view Kepware's repository of more than 500 Knowledge Base articles. Narrow your results or type your query into the search field below.

Search Solutions Results By: View All Solutions

Kepware Knowledge Base: Solution


Can I Set Up a DDE Connection from Excel to KEPServerEX?


Last Update: 11/7/2018

Because DDE is resource intensive, it is not recommended for users that are going to read and write a lot of data. Those users should utilize an OPC connection in an Excel form instead. For users that insist on utilizing DDE, the proper formula is =<Application Name>|<Topic>!<Item> where:

  • Application Name: By default, this is set to "Kepdde".
  • Topic: The global topic is "_DDEData".
  • Item: When using the global topic, this is the same as an OPC item name. It will be "channel.device.tag".

Note: For DDE connections to work, users must be running the server interactively on the desktop and not as a service. The default setting for KEPServerEX V4 is Interactive Mode (on the desktop). The default setting for KEPServerEX V5 is Service Mode.

See Also: KEPServerEX, DDE, and Excel

Tags
Excel

Related Products
DDE Client