Microsoft Office Tutorials and References

In Depth Information

**Table 15-3. Excel 10 objects with 5 or more children**

DiagramNodes (1)

PivotFormulas (2)

Watches (2)

Dialog (1)

PivotItem (4)

WebOptions (1)

Dialogs (2)

PivotItemList (2)

Window (7)

DisplayUnitLabel (6)

PivotItems (2)

Windows (2)

DownBars (4)

PivotLayout (4)

Workbook (14)

DropLines (2)

PivotTable (8)

Workbooks (2)

Error (1)

PivotTables (2)

Worksheet (17)

ErrorBars (2)

PlotArea (4)

WorksheetFunction (1)

ErrorCheckingOptions (1)

Point (5)

Worksheets (3)

Errors (2)

Points (2)

Table 15-3
shows the Excel objects that have at least five children. As we can see by comparing

the sizes of Tables 15-2 and 15-3, most objects by far have fewer than five children.

Table 15-
. Excel 10 objects with 5 or mo
re children

Application (32)

DataLabel (6)

Point (5)

Axis (6)

DataLabels (6)

Range (22)

AxisTitle (6)

DisplayUnitLabel (6)

Series (6)

Chart (16)

Legend (5)

Shape (22)

ChartArea (5)

OLEObject (5)

ShapeRange (17)

ChartGroup (7)

OLEObjects (6)

Window (7)

ChartObject (6)

PivotCell (6)

Workbook (14)

ChartObjects (6)

PivotField (5)

Worksheet (17)

ChartTitle (6)

PivotTable (8)

This list shows the only Excel 10 objects whose child count is in the double digits:

Application (32)

Shape (22)

Range (22)

Worksheet (17)

ShapeRange (17)

Chart (16)

Workbook (14)

Indeed, much of the power of the Excel object hierarchy is concentrated in the seven objects and

much of the remainder of this topic is devoted to those objects.

15.2 Excel Enums

It is also interesting to glance over the list of Excel enums, whose names begin with Xl (with the

enums for Excel 8, 9, and 10, along with a count of the number of constants per enum. Note that

there are some rather large enums in the object model. The enums with at least 20 constants are:

•
XlBuiltInDialog (241)

•
Constants (167)

•
XlChartType (73)