Vous voulez voir cette page en français ? Cliquez ici.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
18 used & new from CDN$ 13.09
Have one to sell? Sell yours here
 
   
Excel 2002 VBA: Programmers Reference
 
 
Share your own customer images
Search inside this book

Excel 2002 VBA: Programmers Reference (Paperback)

by Rob Bovey (Author), Stephen Bullen (Author), John Green (Author), Robert Rosenberg (Author) "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..." (more)
4.6 out of 5 stars  See all reviews (12 customer reviews)
List Price: CDN$ 47.99
Price: CDN$ 30.23 & eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details
You Save: CDN$ 17.76 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.ca. Gift-wrap available.

Only 1 left in stock--order soon (more on the way).

11 new from CDN$ 30.23 7 used from CDN$ 13.09

Frequently Bought Together

Customers buy this book with Excel VBA Programming For Dummies by John Walkenbach

Excel 2002 VBA: Programmers Reference + Excel VBA Programming For Dummies
Price For Both: CDN$ 43.73

Show availability and shipping details

  • This item: Excel 2002 VBA: Programmers Reference by Rob Bovey

    In Stock.
    Ships from and sold by Amazon.ca.
    Eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details

  • Excel VBA Programming For Dummies by John Walkenbach

    In Stock.
    Ships from and sold by Amazon.ca.
    Eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details

Product Details

Product Description

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



Book Info

Based on the successful content and format of Excel 2000. Fully updated for Excel 2002. Introduces Excel and VBA, and offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers. Real-world examples included. Softcover.
See all Product Description
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:

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
Your tags: Add your first tag
 
See most popular tags
 

Customer Reviews

12 Reviews
5 star:
 (9)
4 star:
 (1)
3 star:
 (2)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.6 out of 5 stars (12 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most helpful customer reviews

 
5.0 out of 5 stars If you are reading this review, buy this book now., Dec 3 2003
By Dennis Eichenlaub (Kingsville, MD United States) - See all my reviews
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 (Report this)



 
4.0 out of 5 stars A Must have, Oct 6 2003
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 (Report this)



 
5.0 out of 5 stars Great book!, Jul 22 2003
By Ruslan Moskalenko "Ruslan Moskalenko" (Pleasanton, CA United States) - See all my reviews
(REAL NAME)   
This review is from: Excell 2002 VBA Programmers Reference (Paperback)
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!
Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 		 Most recent customer reviews

3.0 out of 5 stars Wrox, please hire an indexing expert!!!
The book would get 5 stars from me if only Wrox would spend the money on hiring an indexer for this book. Read more
Published on May 15 2003 by K. J. Jarnot

5.0 out of 5 stars As good as it gets
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 more
Published on May 13 2003 by Federico De Vita

5.0 out of 5 stars That's the way...
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 more
Published on Feb 13 2003 by ovma

5.0 out of 5 stars Advanced
The reader of this book must have programming knowledge and be a proficient Excel user. This was not written for absolute beginners. Read more
Published on Jan 13 2003 by Antonios Giannakas

3.0 out of 5 stars Great Book, But Fix The Index
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 more
Published on April 23 2002

5.0 out of 5 stars Excellent!
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. Read more
Published on April 19 2002 by John Davis

5.0 out of 5 stars Great new version of the book
Hello Excel users

If you want to learn about programming in Excel there are two books that you must have near your computer. Read more

Published on Nov 16 2001 by ron de bruin

5.0 out of 5 stars Superb book, ecellent content
I wholeheartedly recommend this new book written by this famous foursome. It bulges with useful information, which is very well written indeed. Read more
Published on Nov 5 2001 by Jan Karel Pieterse

5.0 out of 5 stars At long last a book that lists the object model details
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. Read more
Published on Oct 27 2001

Only search this product's reviews


Look for similar items by category

Look for similar items by subject























i.e., each book must be in subject 1 AND subject 2 AND ...

Feedback

Would you like to update product info or give feedback on images?

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.