Microsoft Office Tutorials and References
In Depth Information
Table 17-2. Members of Workbook that return children
Table 17-2 gives the members of the Workbook object that return children.
Table 17-2. Members of Workbo ok that return children
Name
ReturnType
ActiveChart
Chart
Application
Application
Charts
Sheets
CustomViews
CustomViews
DialogSheets
Sheets
Excel4IntlMacroSheets
Sheets
Excel4MacroSheets
Sheets
Mailer
Mailer
Modules
Sheets
Names
Names
NewWindow
Window
PivotCaches
PivotCaches
PublishObjects
PublishObjects
RoutingSlip
RoutingSlip
Sheets
Sheets
SmartTagOptions
SmartTagOptions
Styles
Styles
WebOptions
WebOptions
Windows
Windows
Worksheets
Sheets
There are a few items worth noting about Table 17-2 First, the ActiveSheet property may return .
either a Chart object or a Worksheet object, depending upon what type of object is currently active.
Second, the Charts, Sheets, and Worksheets properties all return a (different) Sheets collection. In
particular, the Charts object returns the Sheets collection that contains all of the chart sheets in the
workbook. (This does not include charts that are embedded in worksheets.) The Worksheets
property returns the Sheets collection of all worksheets in the workbook. Finally, the Sheets
property returns the Sheets collection of all worksheets and chart sheets. This is a relatively rare
example of a collection that contains objects of more than one type. Note that there is no Sheet
object in the Excel object model.
 
 
 
Search JabSto ::




Custom Search