Read values from the communication driver into Excel

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

=applicationname|topicname!itemname

Example formula:

=DASABTCP|ABPLC!'N7:0'

where:

DASABTCP is the name of the Communication Driver application.

ABPLCis the exact topic name defined in the Communication Driver 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 Communication Driver 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.