Microsoft Office Tutorials and References
In Depth Information
16.1.1 Members that Return Children
We will also discuss additional properties and methods of the Application object throughout the
remainder of the topic, hopefully at times when the discussion will be more relevant.
In the hope of making our discussion a bit more structured, we will try to break the members in
Table 16-1 into separate groups. Note, however, that this is in many cases a bit arbitrary.
16.1.1 Members that Return Children
Many of the members of the Application object are designed simply to gain access to a child
object of the Application object. For instance, the Workbooks property simply returns the
Workbooks collection object, which represents all of the currently open Workbook objects (i.e.,
workbooks). We will discuss many of these objects at the proper time, but it is worth taking a look
at the members that return these objects now.
Table 16-2 shows the 48 members of the Application object that return child objects.
Table 16-2. Members that return child objects
Name
ReturnType
ActiveCell
Range
ActiveChart
Chart
ActiveDialog
DialogSheet
ActiveMenuBar
MenuBar
ActiveWindow
Window
ActiveWorkbook
Workbook
AddIns
AddIns
Application
Application
AutoCorrect
AutoCorrect
AutoRecover
AutoRecover
Cells
Range
Charts
Sheets
Columns
Range
DefaultWebOptions
DefaultWebOptions
Dialogs
Dialogs
DialogSheets
Sheets
ErrorCheckingOptions
ErrorCheckingOptions
Excel4IntlMacroSheets
Sheets
Excel4MacroSheets
Sheets
FindFormat
CellFormat
Intersect
Range
MenuBars
MenuBars
Modules
Modules
Names
Names
NextLetter
Workbook
ODBCErrors
ODBCErrors
OLEDBErrors
OLEDBErrors
Parent
Application
Range
Range
RecentFiles
RecentFiles
 
Search JabSto ::




Custom Search