Visual Basic Concepts

Declaring an Object Variable

Before you can use the properties, methods, and events of an object provided by an ActiveX component, you must first declare an object variable. The way you declare an object variable depends on whether or not the ActiveX component supplies a type library.

To declare a variable for an object defined in a type library

  1. Add a reference to the type library to your Visual Basic project. For more information on adding a reference to a type library, see "Creating a Reference to an Object" earlier in this chapter.

  2. Specify the name of a class supplied by that type library in your variable declaration. Declaring an object variable of a specific class can speed object references. Use the following syntax:

    DimvariableAs [New] class

    The class argument can be composed of two parts, in the form component.class.

Part Description
component The name of the component that supplies the object. Choices are displayed in the Project/Library list of the Object Browser.
class The object's class name (provided by the component's type library). Choices are shown in the Classes/Modules box of the Object Browser.

For example, you can declare a variable for a Microsoft Excel Chart object in either of the following ways:

Dim xlChart As Chart
Dim xlChart As Excel.Chart

If you declare an object variable using the New keyword, Visual Basic will automatically create an object and assign an object reference the first time you use the variable. For example, the following statements assign a reference to a new DAO table object to the variable tdfOrders, setting the table's Name property to "Orders":

Dim tdfOrders As New TableDef
tdfOrders.Name = "Orders"

Note   Using variables declared using the New keyword can slow your application. Every time Visual Basic encounters a variable declared using New, it must test whether or not an object reference has already been assigned to the variable.

To declare an object variable for an object not defined in a type library

  • Declare an object variable of the generic Object class, as follows:

    DimvariableAs Object

For example, the variable objAny in the following declaration can be used for a Microsoft Excel Chart object or any other object provided by an ActiveX component:

Dim objAny As Object

The main difference between declaring a variable of a specific class and declaring a variable of the generic Object class is in how ActiveX binds the variable to the object. When you declare a variable of the generic Object class, ActiveX must use late binding. When you declare an object variable of a specific class, ActiveX uses early binding,**which can speed object references. For more information, see "Speeding Object References" later in this chapter.

For More Information   For more information on declaring object variables, see "Dim Statement." For more information on assigning an object reference to a variable, see "Assigning an Object Reference to a Variable."