User`s guide

252 VEE User’s Guide
6 Creating Reports Easily Using ActiveX Chapter
For example, if you select Data ⇒ Variable ⇒ Declare Variable, set
the Name to App, and set the data type as Object, you can use
the variable App to point to an ActiveX Automation object such
as the Excel Automation Server. Figure 147 shows an
example of a data type Object.
Figure 147 Example of Data Type “Object”
Performing Operations Using ActiveX Statements
To communicate with an ActiveX Automation server, such as
the Excel Automation Server, enter ActiveX commands in a
VEE Formula object. For example, Figure 148 shows a VEE
Formula object that has been named Set Up Excel Worksheet. It
contains a list of commands to set up an Excel worksheet to
display the results of a test.