User`s guide

268 VEE User’s Guide
6 Creating Reports Easily Using ActiveX Chapter
Figure 158 A VEE to MS Excel Program Example
The entries in Figure 158 are as follows:
Table 2 8 Description of Figure 13’s Entries
Item Description
MS Excel Window
Size
Notice the Drop-Down List in the upper right work area.
This allows you to choose one of three options
xlMaximized, xlMinimized, xlNormal to select the size
of the worksheet window inside Excel when it comes up.
Each window size is associated with a number, which VEE
calculates and puts in the
wndState variable. This value is
then assigned to the
windowState property in the Excel
library.