Office® XP Development with VBA

The Excel Object Model

At the heart of the Excel object model is the Worksheet object, representing a single page in the file. Each Worksheet object is part of the Worksheets collection, which is subsidiary to a Workbook object, representing a single Excel file. Because the Excel application can have more than one workbook open at a time, there is also a Workbooks collection that contains one Workbook object for each open file. As with all Office applications, the Application object is at the top of the object hierarchy and is available as an implicit reference if you are working in Excel.

A second kind of “page” in a workbook is a Chart, a type of sheet that contains only a chart. The Application object's Charts collection provides access to ...