Product Manual

21
You may create a chart based on the numeric cells. As the weight changes the value in
the cell and the chart display will automatically update.
Quattro Pro for Windows
To read the weight string into a Quattro Pro for Windows spreadsheet cell enter the
following:
@DDELINK([WINDDE|SCALE]"STR")
This will provide automatically updating data in the spreadsheet cell. To read the
numeric weight into the cell replace the "STR" with "WT."
Lotus 1-2-3 for Windows
For one time data access create a macro with the following commands. Make sure the
cell A1 is not in use.
{DDE-OPEN "WINDDE","SCALE"}
{DDE-REQUEST A1,"STR"}
{DDE-CLOSE}
Run the macro. It will insert the current weight string into the cell A1. Note, the data
will not update automatically.
For automatically updating data create three macros. Create the first macro starting at
cell A3.
{DDE-OPEN "WINDDE","SCALE"}
{DDE-ADVISE A9,"STR"}
This macro starts the communications. The second line sets the communications mode
to advise of changes in the data and run the macro at cell A9 when the data changes.
Create the second macro at cell A9.
{DDE-REQUEST A1,"STR"}
This macro is called automatically when the item, "STR", changes. The macro requests
the information from the server and places the data in cell A1. Create a third macro at
cell A12.
{DDE-CLOSE}
Run this macro to stop the communications.