Watlow LogicPro - Manual (Page 282)

Chapter 17: Dynamic Data Exchange LogicPro User’s Guide
266 Watlow Anafaze Doc.# 28002-00 Rev 3.00
NOTE! You must exit LogicPro to free the communica-
tion channel or an error box will appear when the
LogicPro DDE is started.
Setting Up Excel to Read
Using the spreadsheet as a sample, the DDE Server reads the
Variables and places their values in the specified cells. The
spreadsheet reads Variables and shows a chart reflecting those
values, as shown in Figure 17.2.
Figure 17.2 Spreadsheet Example
To specify a specific Variable inside the controller, call the
LP_DDE Server and request the data. In the DDE Server, use
Topic1 which you configured earlier. Topic1 uses the .FPR
file for the configuration of the controller.
Excel provides an easy way to read a value from a DDE and
place it into a cell. The correct format is:
=SERVER NAME|TOPIC NAME|ITEM NAME
• Server Name — LP_DDE. This is the executable file
name for the LogicPro DDE server.
• Topic Name — the name that was assigned at the New
Topic dialog box.
• Item Name — the symbolic Variable name that is used
in the Program.