I talked a little about the
Application object back in Chapter 4.
Application is where everything starts in Excel: it’s the grandma of all the other objects. You use the
Application object to:
Perform top-level actions, such as quitting Excel, showing dialog boxes, or recalculating all workbooks
Control the Excel options, such as the settings on the Tools → Options dialog box
Get references to the other objects in Excel
In this chapter, you will learn about those tasks
in detail. This chapter includes task-oriented reference information for the following objects:
Code used in this chapter and additional samples are available in ch07.xls.