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


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel 2002 VBA: Programmers Reference [Paperback]

Rob Bovey , Stephen Bullen , John Green , Robert Rosenberg
4.6 out of 5 stars  See all reviews (12 customer reviews)
List Price: CDN$ 95.99
Price: CDN$ 60.47 & FREE Shipping. Details
You Save: CDN$ 35.52 (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
Usually ships within 1 to 3 months.
Ships from and sold by Amazon.ca. Gift-wrap available.

Formats

Amazon Price New from Used from
Paperback CDN $60.47  
Save Up to 50% on "For Dummies" Books
Lighthearted but not lightweight, For Dummies books are great references not only for tackling new subjects but also for brushing up on subjects with which you're already familiar. Get results while saving up to 50%. See more.
Join Amazon Student in Canada


Book Description

Sept. 26 2001 Programmer to Programmer
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.


Customers Who Bought This Item Also Bought


Product Details


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:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

4.6 out of 5 stars
4.6 out of 5 stars
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?
4.0 out of 5 stars A Must have 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?
5.0 out of 5 stars Advanced 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?
5.0 out of 5 stars Excellent! 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?
By A Customer
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?
5.0 out of 5 stars Great new version of the book Nov. 16 2001
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?
Want to see more reviews on this item?
Most recent customer reviews
Search Customer Reviews
Only search this product's reviews

Look for similar items by category


Feedback