Chapter 7. Controlling Excel
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: Application, AutoCorrect, AutoRecover, ErrorChecking, Windows, and Panes.
Tip
Code used in this chapter and additional samples are available in ch07.xls.
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
