Writing Values To The I/O Server From Excel - Siemens 3964R User Manual

Writing Values to the I/O Server from Excel

Values may be written to the server from Microsoft Excel by creating an Excel macro
that uses the POKE command. The proper command is entered in Excel as follows:
The following describes each of the above POKE macro statements:
Opens a channel to a specific topic name (defined in the server) in a particular
application name (the executable name less the .EXE) and assigns the number of that
opened channel to channel.
Note By using the channel=INITIATE statement the word channel must be used in
the =POKE statement instead of the actual cell reference. The "applicationname"
and "topicname" portions of the formula must be enclosed in quotation marks.
POKEs the value contained in the Data_Reference to the specified item name (actual
location in the PLC) via the channel number returned by the previously executed
INITIATE function. Data_Reference is the row/column ID of the cell containing the
data value.
Closes the channel at the end of the macro. Some applications have a limited number
of channels therefore, they should be closed when finished. Channel is the channel
number returned by the previously executed INITIATE function.
Marks the end of the macro.
Note Refer to the .XLM sample Excel poke macro provided on the server program
disk. Also refer to the Microsoft Excel manual for complete details on entering Remote
Reference formulas for cells.
channel=INITIATE("applicationname","topicname")
=POKE(channel,"itemname", Data_Reference)
=TERMINATE (channel)
=RETURN()
channel=INITIATE("applicationname","topicname")
=POKE(channel,"itemname", Data_Reference)
=TERMINATE(channel)
=RETURN()
25