Excel 2002 VBA: Programmers Reference

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.

Download Description
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.

I bought "Excel 2002 VBA Programmer's Reference". I sat down and started reading Chapter 2. Before long, I was so excited that I was firing up my laptop. Four hours after I started reading the book, I had a prototype up and running. This book is amazing. Chapter 2 gave me more useful information than I sometimes get from an entire book. ...

The authors are simply bursting with knowledge and give it freely. Ideas are expressed clearly and succinctly. Knowledge is well-organized and easy to find. Whether you want to approach the topic methodically or flip through looking for gems, you will find what you want here.

Getting the object model is a great bonus. I'm going to enjoy spending a few days going through this one.


A Must have   October 6, 2003
2005 Astoria user (NY, USA)
11 out of 11 found this review helpful

The book is adressed both to beginners and intermediate users, not advanced ones though. It covers everything, however there were many occasions where I wanted more information. This is not to say the book is not a great value for money. After all, a complete vba book would probably need to have a couple of thousand pages, whereas with this book you can start programming even having read only chapter 2. If money is not an issue, you also need to buy Walkenbach's vba book too.

I found it easy to navigate through it, so I didn't think indexing was such a great problem as commented before me. The authors don't say too little or too much and they write very clear. The reason I didn't put 5 stars (if I had the option I would put 4.5 starts) was because I didn't like the second part of it, which is half the book and which mostly presents basic information.


Great book!   July 23, 2003
Ruslan Moskalenko (Pleasanton, CA United States)
7 out of 7 found this review helpful

It's a great book! It actually consists of two parts: a brief but very useful VBA overview with all popular tricks and hints in the beginning and a deep and coplete reference at the end. Normally you need to buy two separate books to get this coverage. This book can get you started in a few hours and answer virtually all your questions going forward. Really, really good!