O'Reilly logo

Excel® 2007 VBA Programmer's Reference by Michael Alexander, Rob Bovey, Stephen Bullen, John Green

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix C. Office 2007 Object Model

Common Properties with Collections and Associated Objects

Most of the objects in the Office object model have objects with associated collections. The collection object is usually the plural form of the associated object. For example, the CommandBars collection holds a collection of CommandBar objects. For simplicity, all the objects and associated collections are grouped together under the same heading.

In most cases, the purpose of the collection object is only to hold a collection of the same objects. The common properties of the collection objects are listed in the following section. Only unique properties, methods, or events are mentioned in each object section.

Common Collection Properties

Name

Returns

Description

Application

Application

Read-only. Returns a reference to the application owning the current object.

Count

Long

Read-only. Returns the number of objects in the collection.

Creator

Long

Read-only. Returns a Long number that describes which application the object was created in. Macintosh only.

Parent

Object

Read-only. The Parent object is the container object of the collection object. For example, Workbooks.Parent returns a reference to the Application object.

Common Object Properties

Objects also have some common properties. To avoid redundancy, the common properties of all objects are listed next. They will be mentioned in each object description as existing but are only defined here.

Name

Returns

Description

Application

Application

Read-only. Returns ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required