Excel 2002 VBA: Programmers Reference Paperback – Sep 26 2001
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
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. --This text refers to an out of print or unavailable edition of this title.
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 Microsofts 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 Programmers 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. Thats what Wrox Programmers References deliver. Hard facts on the newest technologies with practical examples of how to apply new tools to your development projects today.See all Product Description
Inside This Book(Learn More)
Excel made its debut on the Macintosh in 1985 and has never lost its position as the most popular spreadsheet application in the Mac environment. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Top Customer Reviews
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.
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.
The book is very lean althogh it is about 1000 pages, it does not offer plenty of examples but the code that is given is very useful. Although could not grasp the chapter's about com add ins and programming the Smarttags I would classify this book as one written in a very clear and approachable way.
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.
I dont think it is a bad book for someone just learning to program either. It may be a little advanced for some. But it isnt insulting by explaining the obvious either
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.
Most recent customer reviews
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... Read morePublished on July 22 2003 by Amazon Customer
The book would get 5 stars from me if only Wrox would spend the money on hiring an indexer for this book. Read morePublished on May 15 2003 by K. J. Jarnot
Truly excellent. Starts from ABC and goes all the way down to Z with a very pleasant and intelligent presentation. One of the best books on programming I have ever come across. Read morePublished on May 13 2003 by Federico De Vita
I'm a beginner in VBA and I bough this book one week ago and I find it excellent. I have tried to learn VBA with other books before with no success. Read morePublished on Feb. 13 2003 by ovma
I bought the previous edition (Excel 2000) of this book and was not satisified at all by the way it was put together. The second edition is a great improvement. Read morePublished on April 23 2002
Look for similar items by category
- Books > Computers & Technology > Microsoft > Development > VBA
- Books > Computers & Technology > Microsoft > Development > Visual Basic
- Books > Computers & Technology > Programming > Software Design, Testing & Engineering > Software Development
- Books > Computers & Technology > Software > Spreadsheets > Microsoft Excel