Excel 2002 VBA Programmers Reference [Illustrated] [Paperback]

Rob Bovey (Author), Robert Rosenberg (Author)

Book Description

Series: Programmer to Programmer | Publication Date: November 15, 2001

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.

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.

This book covers:

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

Editorial Reviews

From the Publisher

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.

From the Back Cover

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.

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.

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.

What does this book cover?

• 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

As an experienced developer, you need to get the facts on a new technology fast. Without the marketing hype, without the trivial introduction. That’s what Wrox Programmer’s References deliver. Hard facts on the newest technologies with practical examples of how to apply new tools to your development projects today. --This text refers to an alternate Paperback edition.

See all Editorial Reviews

Product Details

• Paperback: 1000 pages
• Publisher: Wrox Pr Inc; 1st edition (November 15, 2001)
• Language: English
• ISBN-10: 1861005709
• ISBN-13: 978-1861005700
• Product Dimensions: 9.1 x 7.4 x 2.2 inches
• Shipping Weight: 3.8 pounds
• Average Customer Review: 4.5 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #1,123,392 in Books (See Top 100 in Books)

More About the Author

Rob Bovey is a software developer specializing in Microsoft Office, Visual Basic, and SQL Server applications. He has more than twenty years' experience creating software applications for corporate clients in the financial, engineering, health care, technology and real estate sectors, among others. Rob has operated the independent software development company Application Professionals since 1999.

Rob developed several add-ins shipped by Microsoft for Microsoft Excel. He co-authored the Microsoft Excel 97 Developers Kit, the Excel 2002 VBA Programmer's Reference, the Excel 2007 VBA Programmer's Reference and Professional Excel Development. He was a Microsoft Excel MVP for 15 years. Rob earned his Bachelor of Science degree from The Rochester Institute of Technology and his MBA from the University of North Carolina at Chapel Hill.

Customer Reviews

Most Helpful Customer Reviews

17 of 17 people found the following review helpful:

5.0 out of 5 stars Great new version of the book, November 16, 2001

By 

ron de bruin (monster, zh Netherlands) - See all my reviews

This review is from: Excel 2002 VBA Programmers Reference (Paperback)

Hello Excel users

If you want to learn about programming in Excel there are two books that you must have near your computer.
The first is the 2002 book from John Walkenbach and this one from Bullen, Green, Bovey, Rosenberg.
This 2002 version is better to read then the 2000 version is my opinion and also a lot bigger (from 715 to 993 pages)
The authors have made a great job of making this new version of the Excel 2000 VBA book.
If I must say what I love the most then I say The Object Model in this book is great part of the book.

I am glad that I purchase it.

Regards Ron

13 of 13 people found the following review helpful:

5.0 out of 5 stars Excellent!, April 19, 2002

By 

John Davis (London, UK) - See all my reviews

This review is from: Excel 2002 VBA Programmers Reference (Paperback)

I am an IT consultant with limited programming exposure, but good Excel knowledge. I had a sudden Excel VBA work requirement that meant I had to get going fast. Had heard this was not a book to get started on, but not true, and wouldn't have wanted to learn any other way. No messing around - get stuck in with real world business examples and numerous tips on things to watch out for. Had to focus hard as there is so much information but now 5 weeks later have finished it and feel confident to have a crack at any Excel VBA project. Also now got a good library of code to use.

In fact I enjoyed learning with these guys so much I have ordered a book on programming VB 6.0 to expand my knowledge.

Can't recommend it enough.

12 of 12 people found the following review helpful:

4.0 out of 5 stars A Must have, October 6, 2003

By 

2005 Astoria user (NY, USA) - See all my reviews

This review is from: Excel 2002 VBA: Programmers Reference (Paperback)

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.