Wrox's growing reputation for putting out well-organised, detail-rich books for programmers gets a boost from Excel 2000 VBA Programmer's Reference. This book--a tutorial as well as a reference--holds a wealth of chewy facts that Excel developers will find very valuable.
The tutorial, accounting for half of the book, covers the various mechanisms available for referring to particular files, sheets, cells and ranges of cells. It also addresses the graphical representation of data--particularly in charts--and explains the most important aspects of controls and the events they generate. Green--unlike many VBA authors--covers internationalisation issues in considerable depth. This is the best VBA book on the market for those planning to write programs for a multilingual usage of Excel. There is also a VBA primer that covers critical VBA syntax and the essentials of object-orientation as it applies to the Excel environment.
The two reference sections--one for Excel's VBA objects and one for the VBA Extensibility (VBE) environment--make up the last half of Excel 2000 VBA Programmer's Reference. The references are comprehensive, but they're organised in a strange way--they list properties, methods and events with their names, return data types and descriptions in columns. This would be okay, but when an object's list of members extends over several pages it's impossible to be immediately sure of which object the list refers to. The object name ought to appear on each page. --David Wall --This text refers to an out of print or unavailable edition of this title.
This book is for the Excel developer or user who already has a knowledge of spreadsheets, and the basic objects of an Excel spreadsheet, and now wants a solid and detailed reference to the main object models present in the Excel structure with examples of how to use these models. --This text refers to an out of print or unavailable edition of this title.See all Product Description
I needed more detail on how to get the code in the book to run. The book has lots of code examples, but I rarely could get them to run. Read morePublished on Aug. 19 2002 by Ronald Brown
This book would have gotten 4 stars from me if it were not for the index. For example, in one short block of code, I tried looking up Resize, What:, LookAt, xlWhole, LookIn, and... Read morePublished on April 8 2002 by Polymath-In-Training
I was thrown into a contract position programming Excel 97 (yeah, i know). I thought i would just get in there, and code up some sweetness and be done. Read morePublished on March 16 2002 by "enfranchise"
I had expected a simple, straitforward reference book, yet it goes the extra mile by explaining important concepts superbly. I use it now, more than I had thought I would. Read morePublished on March 5 2002 by mattgb1
As the title states, it is a programmer's reference. Do not buy this book if you need to learn VBA. Also, it had many good tips, but I was not able to find them again with the... Read morePublished on Nov. 26 2001
The book is an excellent reference for Intermediate and Advanced VBA developers. I started programming with Excel 95. Personally, I prefer the Wrox books over Walkenbach anyday. Read morePublished on Oct. 13 2001 by Adria Bynum
Those with no programming backround may find this a little advanced. I first read Walkenbach's Power Programming for Excel 2000 which was very good and then followed with this book... Read morePublished on Sept. 5 2001 by John A. Bigness
I have had high expectations towards this book. After reading a few chapters, I found this book a difficult to follow. I had expected a self-study guide, but I was wrong. Read morePublished on July 2 2001
I had a really a high expectations towards this book However, after reading a few chapters I realized that this is not a good guide for a self-study. Read morePublished on June 30 2001