Microsoft Office Tutorials and References
In Depth Information
Chapter 15. The Excel Object Model
Chapter 15. The Excel Object Model
The Excel object model is one of the most extensive object models in Microsoft's arsenal, with
almost 200 objects and over 5000 properties and methods. As we have mentioned, however, many
of these objects and members are included solely for backward compatibility with earlier versions
of Excel. When we ignore these objects and members, the object count drops to 140 and the
member count is about 3000. This makes the Excel object model second in size only to the Word
object model.
We will not discuss the objects and members that are included for backward compatibility only.
However, since you should at least be aware of the existence of these objects, we will include
them in our pictures of the model (appropriately marked) but not in the tables.
It is certainly not our intention in this topic to cover all, or even most, of the objects and members
of the Excel object model. Our goal is to acquaint you with the major portions of this model, so
that you can easily learn more as needed.
It seems appropriate to begin by trying to present an overall view of the Excel object model.
15.1 A Perspective on the Excel Object Model
To put the Excel object model in some perspective, Table 15-1 gives some statistics on various
Microsoft object models for Office 97 (the numbers are somewhat larger for later versions of
Office).
Table 15-1. Some Object Model Statistics for Office 97
Application
Objects
Properties
Methods
Enums
Constants
Access 8
51
1596
32 5
31
85 4
Binder 8
4
37
5 1
4
1 1
DAO 3.5
37
35 2
74 1
26
85 1
Excel 8
192
245 3
716 1
152
266 1
Forms 2
64
588
52 3
42
91 1
Graph 8
44
1120
34 2
58
47 4
Office 97
40
615
09 2
78
01 8
Outlook 8
42
1568
34 5
34
54 1
PowerPoint 8
110
197 1
22 3
53
70 3
Word 8
188
2300
37 8
192
969 1
For reference, Table 15-2 shows all nonhidden objects in the Excel XP object model, along with
the number of children for each object.
Table 15-2. E xcel 10 objects and their child counts
AddIn (1)
FillFormat (1)
Protection (1)
AddIns (2)
Filter (1)
PublishObject (1)
Adjustments (0)
Filters (2)
PublishObjects (2)
AllowEditRange (2)
Floor (4)
QueryTable (3)
AllowEditRanges (1)
Font (1)
QueryTables (2)
 
 
 
 
 
Search JabSto ::




Custom Search