O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required