Reading Values from the DAServer into Excel

Values may be read directly into Excel spreadsheets from the DAServer by entering a DDE formula into a cell using the following format:

=applicationname|topicname!itemname

Example formula:

=DASABTCP|ABPLC!'N7:0'

where:

DASABTCPis the name of the DAServer application.

ABPLCis the exact topic name defined in the DAServer for the PLC.

N7:0Is the actual location in the PLC that contains the data value. This is the item name.

In this example, each time the value of N7:0 changes in the PLC, the DAServer will automatically send the new value to the cell containing the formula in Excel.

Note: Refer to the Microsoft Excel manual for complete details on entering Remote Reference formulas for cells.