Excel® 2007 VBA Programmer's Reference

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 ...