Program powerful Excel solutions with VBA: A close look at the Application object

Users know Excel is a powerful platform for solving complex calculations and presenting results. But Programming Excel with VBA and .NET demonstrates how Visual Basic for Applications (VBA) can be used to take Excel a step further, transforming it from a general platform into a task-specific piece of software that quickly and precisely serves a user's needs. This sample chapter from the book looks closely at the Application object, which is where everything starts in Excel. The Application object is used 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. The chapter examines these tasks in detail. The chapter includes task-oriented reference information for the following objects: Application, AutoCorrect, AutoRecover, ErrorChecking, Windows, and Panes.
  
  Title: Programming Excel with VBA and .NET
  Authors: Jeff Webb and Steve Saunders
  Publisher: O'Reilly Media, Inc.
  Chapter 7: Controlling Excel
  ISBN: 0596007663; Copyright © 2006 O'Reilly Media. All rights reserved.
  Web site
  Previously published book chapters on TechRepublic can be found using the book chapter tag.