Excel 2002 VBA: Programmers Reference | 
 enlarge | Authors: Rob Bovey, Stephen Bullen, John Green, Robert Rosenberg
Publisher: Wrox
Category: Book
List Price: $39.99
Buy New: $9.55
You Save: $30.44 (76%)
New (23) Used (10) from $5.50
Rating:  14 reviews
Sales Rank: 415131
Media: Paperback
Pages: 1032
Number Of Items: 1
Shipping Weight (lbs): 3.2
Dimensions (in): 9 x 7.3 x 2.1
ISBN: 0764543717
Dewey Decimal Number: 005.54
UPC: 785555875173
EAN: 9780764543715
ASIN: 0764543717
Publication Date: September 26, 2001
Availability: Usually ships in 1-2 business days
Condition: New Publisher's Overstock! May have a small remainder mark.All orders shipped within 1 business day! Delivery confirmation emails including tracking numbers provided on all domestic orders. All eligible international orders are shipped via USPS Priority International.
| |
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
VBA is the programming language for the Microsoft(r) 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(r) 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.
|
| Customer Reviews: Read 9 more reviews...
 Good Reference for Excel VBA Developers November 6, 2007
K. Scott Proctor (Wilmington, DE USA)
"Excel 2002 VBA Programmer's Reference" is a good reference for those who write code in Excel VBA. To those familiar with Microsoft Excel, but unfamiliar with the VBA (Visual Basic for Applications) programming environment, this book should serve as a good way to learn how to automate tasks and extend the utility of Excel.
Most appropriate for intermediate- to advanced-users, this book still offers a primer in Excel VBA for those new to VBA. Note that this is a large book (approximately 1,000 pages) and it contains a printed version of the Excel 2002 Object Model, which can prove useful to those who prefer paper-based, as opposed to screen-based, reference information.
Overall, a very good reference book.
 Slightly better than average March 24, 2005
tim_sf
2 out of 6 found this review helpful
The best aspect of this book is it's section on ADO, but there is little depth into the topic. How frustrating to find something so powerful and so undocumented, only to see the end of the chapter so quickly.
I suppose I do not see why 400 pages was devoted to the Excel object model. I do not use the section, but instead search within the VBE for information and arguments I need.
The book is cheap. The binding broke in 2 places.
If you are reading this review, buy this book now. December 3, 2003
Dennis Eichenlaub (Kingsville, MD United States)
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.
 A Must have October 6, 2003
2005 Astoria user (NY, USA)
11 out of 11 found this review helpful
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.
Great book! July 23, 2003
Ruslan Moskalenko (Pleasanton, CA United States)
6 out of 6 found this review helpful
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!
|
|
|
