User`s guide

Creating Reports Easily Using ActiveX Chapter 6
VEE User’s Guide 269
Memory Tracking (Click Show Terminals in the Properties boxes on the
Formula and Meter objects.) Notice the
memoryTotal and
memoryUsed properties in the Excel library that are
assigned to the VEE variables memTotal and memUsed.
These values are then used to calculate the ranges to
configure a VEE meter before it displays the memory being
used by MS Excel.
Number Format Notice how easy it is to add a dollar sign to the number
format.
sheet.SaveAs
(filename)
The SaveAs() method is being called from the Excel library
to automatically save the worksheet. Notice that a
File
Name Selection
box (from the Data ⇒ Dialog Box
menu) is used to display the pop-up Save As box from VEE.
The file name you select is then used as a parameter in the
Excel SaveAs() method call.
Press to Kill Excel The Confirm (OK) button has been used to signal when you
want to close Excel.
Close Excel The quit() method is called to tell MS Excel to exit.
Table 2 8 Description of Figure 13’s Entries
Item Description