Wiley.com
Print this page Share

Excel 2002 VBA: Programmers Reference

ISBN: 978-0-7645-4371-5
Paperback
1032 pages
September 2001
List Price: US $79.99
Government Price: US $51.19
Enter Quantity:   Buy
Excel 2002 VBA: Programmers Reference (0764543717) cover image
This is a Print-on-Demand title. It will be printed specifically to fill your order. Please allow an additional 15-20 days delivery time. The book is not returnable.

What is this book about?

VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment.

Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft's commitment to moving Office to be a web-enabled productivity tool, a rich client for working with web-based data, with new features such as SmartTags and XML support.

Based on the successful content and format of Excel 2000 VBA Programmer's Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community.

What does this book cover?

The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers, with real-world examples answering frequently asked questions. The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models.

Here are just a few of the things you'll learn in this edition:

  • The entire Excel Object Model and the Common Office Object Model
  • Working with PivotTables
  • Accessing and manipulating data sources from Excel with ADO
  • Programming the Visual Basic Editor (VBE)
  • New features in Excel 2002, SmartTags, XML, and the Web
  • Expanded references for Excel versions 97, 2000, and 2002

Who is this book for?

This book not only caters for beginner- and intermediate-level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.

Related Titles

More By These Authors

General Programming & Software Development

by John Kauffman, Fabio Claudio Ferracchiati, Brian Matsik, Eric N. Mintz, Jan D. Narkiewicz, Kent Tegels, Donald Xie, John West, Jesudas Chinnathampi, James Greenwood
by Andrew Filev, Tony Loton, Kevin McNeish, Ben Schoellmann, John Slater, Chaur G. Wu
by Robert Smith, Dave Sussman, Ian Blackburn, John Colby, Mark Horner, Martin Reid, Paul Turley, Helmut Watson
by Dave Brueck, Stephen Tanner
Back to Top