Program powerful Excel solutions with VBA: A close look at the Application object
Source: O'Reilly Media
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.