Chapter 6 267
Creating Reports Easily Using ActiveX
Creating an Agilent VEE to MS Excel Template
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.
To Next Page
Loading...
Need help?
General
