CDN$ 60.47
  • List Price: CDN$ 95.99
  • You Save: CDN$ 35.52 (37%)
Usually ships within 1 to 3 months.
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
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: Programmers Reference Paperback – Sep 26 2001


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback
"Please retry"
CDN$ 60.47
CDN$ 56.28 CDN$ 1.22

Up to 90% Off Textbooks

Customers Who Bought This Item Also Bought



Product Details

  • Paperback: 1032 pages
  • Publisher: Wrox; 1 edition (Sept. 26 2001)
  • Language: English
  • ISBN-10: 0764543717
  • ISBN-13: 978-0764543715
  • Product Dimensions: 18.5 x 5.3 x 23 cm
  • Shipping Weight: 1.5 Kg
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Bestsellers Rank: #1,074,994 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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


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
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4.6 out of 5 stars
Share your thoughts with other customers

Most helpful customer reviews

Format: Paperback
If you are interested enough to read this review, then buy this book. Now. I have done quite a bit of programming ... The only problem was, I had never programmed VBA/Excel and was having a very rough time getting started.
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.
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.
By 2005 Astoria user on Oct. 6 2003
Format: 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.
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.
By Antonios Giannakas on Jan. 13 2003
Format: Paperback
The reader of this book must have programming knowledge and be a proficient Excel user. This was not written for absolute beginners. The book is best where it covers advanced feature's such as Add ins, programming the VBE, Windows API,Class Modules and writing international applications. However If you buy this book I would recommend WalkenBach's "Excel Power Programming..." which offers a better coverage of Userforms, Charts, Toolbars and Menu's.
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.
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.
By John Davis on April 19 2002
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.
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.
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
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.
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
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.


Feedback