User`s guide

Creating Reports Easily Using ActiveX Chapter 6
VEE User’s Guide 253
Figure 148 Commands to Set Up Excel Worksheet to Display Test Reults
VEE uses standard Microsoft Visual Basic syntax to create the
commands or statements like those shown in Figure 148.
The commands or statements perform three types of
operations: get properties, set properties, or call methods.
• Get property statements usually refer to getting some type of
data. The syntax is <object>.<property>. For example,
sheet.application gets the application property of the sheet
object.
• Set property statements usually refer to setting some type of
data equal to something. The syntax is <object>.<property> =
<property type>. For example, object.property = MaxSize sets a
property.
• Call methods call a method. A method requests the object to
perform an action. Methods have parameters that allow data
to be passed in and returned. The syntax is
<object>.<method>(parameters).
NOTE
The syntax for data type Objects looks similar to the VEE syntax for getting
a Record field, rec.field, and calling a UserFunction, myLib.func(), so it is
important to assign descriptive names to variables.