
DDEEXAMP.WAS provides a working example of using PROCOMM PLUS 3.0 for Windows ASPECT to establish and control a DDE link with Microsoft Excel.  The script manipulates an example spreadsheet called SODA.XLS.

The spreadsheet is not intended to be a real-life example, but a basis for showing the use of ASPECT as a DDE Client.  Therefore, certain assumptions have been made (see below).

The script allows the user to initiate the DDE session, update the dialog box w/ values from the spreadsheet, add ounces or whole cans to the total amount of soda consumed, report excercise minutes, and exit the script and/or Excel.

In order for the links to Excel and SODA.XLS to function properly, the full name (including path) must be defined for EXCEL.EXE and SODA.XLS in the MACRO DEFINITIONS portion of the source code.

Assumptions:

¹   -   Assuming that the Soda (not just the calories) stays in the body until burned off.
²   -   Assuming that one twelve ounce can of soda contains 150 calories.
³   -   Assuming ten calories burned per minute of excercise.



