FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Excel 2002 VBA Programmer... has been added to your Basket
+ £2.80 UK delivery
Used: Very Good | Details
Condition: Used: Very Good
Comment: This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See more of our deals.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Excel 2002 VBA Programmer's Reference (Programmer to Programmer) Paperback – 26 Sep 2001

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
"Please retry"
£28.93 £0.01
£55.00 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Product details

  • Paperback: 1032 pages
  • Publisher: John Wiley & Sons; New edition edition (26 Sept. 2001)
  • Language: English
  • ISBN-10: 0764543717
  • ISBN-13: 978-0764543715
  • Product Dimensions: 18.5 x 5.3 x 23 cm
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 1,137,372 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

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.

About the Author

John Green works as an independent computer consultant and established his company, Execuplan Consulting, which specializes in developing computer based planning applications and in training. He′s led training courses for software applications and operating systems and has been accorded the status of Most Valuable Professional by Microsoft for his contributions to the CompuServe Excel forum and MS Internet newsgroups. Contact him at Stephen Bullen set–up his own company called Business Modelling Solutions Ltd, which specialises in Excel and Access development and consulting. The BMS web site contains a large number of examples of his work, including tools and utilities to extend Excel′s functionality and many examples of Excel development techniques. Stephen can be contacted by email to Rob Bovey is a software developer and is founder and president of the custom application development firm, Application Professionals. Rob developed several Addins shipped by Microsoft for Excel. He also co–authored the Microsoft Excel 97 Developers Kit. Microsoft has awarded him the title of Most Valuable Professional each year since 1995. Robert Rosenberg runs his own consulting business which specializes in Microsoft Office advanced training and custom solutions. As a Microsoft Valuable Professional in Excel, he also continually offers advanced online support on Excel on behalf of Microsoft to users of their Internet newsgroups. Robert can be contacted on at rrosenberg@r–

Inside This Book (Learn More)
First Sentence
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
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 4 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

20 of 20 people found the following review helpful By O Hannan on 15 Feb. 2002
Format: Paperback
This book is excellent for learning the basics about Excel programming all the way through to an expert user.
Many books claim to teach the advanced parts of Excel but I have been dissapointed in that they do not go all the way as promised.
I am an advanced user of Excel and needed a book that would go beyond pivot tables, basic VBA and macros. This book takes you to furthest and most advanced parts of Excel in a very easy to understand format to develop applications that are truly powerful. I have automated manual processes through this book that has led to several man-days worth of savings in time.
Whenever I have wanted a book that will help me master an application, I have turned to Wrox and they have never let me down!
I would recommend this book as a day to day reference for beginners in VBA/Macro programming to advanced users who really need to tap into the potential of Excel.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
23 of 23 people found the following review helpful By on 30 Jan. 2002
Format: Paperback
This is the most concise Excel VBA guide I have read so for. Absolutely everything is covered in it. It's really easy follow and use. Don't be put off by the title of Excel 2002. It covers the last three versions and makes specific references to any details that may not be relevant to older versions. If you're a beginner,it introduces you very quickly to writing code. So you may be better getting a more basic guide, but for users that are familiar already with VBA to those who would consider themselves 'guru's', it's a must.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By Mr. T. Berriman VINE VOICE on 24 Feb. 2004
Format: Paperback Verified Purchase
I am a self taught VBA programmer and as such I needed a book that would take me that much further, as well as allowing me to brush up on any basics I may have missed. This book does that in volumes. The VBA Primer at the beginning of the book is good enough to get anyone started in VBA right from the beginning, and as the book goes on it goes into more difficult tasks with plenty of sample code. The reference is concise and useful, and it makes a perfect desktop companion. In fact, the only gripe I have about it is it would have been nice to have a CD supplied with it with all the sample code on. Oh well, can't have everything!
Definately worth the money.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Amazon Customer on 24 Jan. 2004
Format: Paperback
This is an excellent book if you need something that will help you do fairly specific things in Excel VBA. I've found it well organised and very useful.
It is beyond the more basic VBA books, and covers things like add-ins, events, etc.
Probably not so useful if you've not used VBA a bit, but if you're going to be writing anything serious in VBA its well worth getting.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on (beta) 15 reviews
17 of 17 people found the following review helpful
Great new version of the book 16 Nov. 2001
By ron de bruin - Published on
Format: 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
Excellent! 19 April 2002
By John Davis - Published on
Format: 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
A Must have 6 Oct. 2003
By 2005 Astoria user - Published on
Format: Paperback Verified Purchase
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.
10 of 10 people found the following review helpful
At long last a book that lists the object model details 27 Oct. 2001
By A Customer - Published on
Format: Paperback
It has been many years since I have done alot of programing. In learning VBA this is the third book I have tried. Most programming books today, are very long winded. Programing is not difficult, if you can actually find the detials of the functions you have available. This is the first book I have found that lists the VBA object model details. I am old fashioned and like to have this in a book, rather than burried in a help file with a talking paper clip to find it for me, or having to record a macro to see what tidbits it can find.
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
10 of 10 people found the following review helpful
Wrox, please hire an indexing expert!!! 15 May 2003
By K. J. Jarnot - Published on
Format: Paperback
The book would get 5 stars from me if only Wrox would spend the money on hiring an indexer for this book. It's very difficult to quickly find which pages have the information you need on most subjects and keywords.
Were these reviews helpful? Let us know