Overview
Get the most out of Excel, Microsoft's powerful spreadsheet application. With John Walkenbach, the leading Excel expert better known as "Mr. Spreadsheet", discover better ways to analyze data and find solutions using Microsoft Excel 2002.This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.
Bonus: The book contains a coupon for the Professional Power Utility Pak.
Synopsis
Master the programming features in Excel 2002 and unleash the power of VBA with expert guidance from "Mr. Spreadsheet" - expert author John Walkenbach!
This is the ideal guide for Excel developers who want to get the most out of Excel with VBA, more than they ever thought was possible. It's also perfect for beginning developers who want to quickly learn how to tap the full potential of Excel programming using VBA. Includes:* Explanation of effective techniques of Excel Application Development
* Thoroughly explains how to use Visual Basic for Applications to add power to Excel Applications
* Gives tricks and tips for interacting with other applications
* Presents info on how to develop Excel utilities with VBA
* Explores the Data Access Object, the powerful feature that makes it easier to work with external database files in VBA
* Shows how to create custom menus, toolbars, help applications, and more
* Gives complete instructions on how to use VBA to design and create 3D charts
* Teaches VBA by presenting extensive code examples in the text
* Provides hundreds of useful examples that demonstrate the most effective methods for implementing VBA