Rating: 
Summary: More useful than I'd hoped
Review: 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. And I expect to continue to do so for some time. A must for the serious developer, especially if you need to weave the Excel Object Model seamlessly into a COM platform.
Rating:
Summary: All the reference detail I needed - and example code too!
Review: I have been writing Excel-based VBA applications for years and always struggled to find a good reference for various functions, properties, and objects. I recently moved up from Excel 97 to Excel 2000 and was struggling. I had continued to use my old Excel 5.0 references because I had trouble finding newer ones that contained substabtial information. Some of my old VBA code wasn't working in Excel 2000 (VBA has been enhanced considerably since Excel 5.0)so I was stuck. I found this book listed at Amazon.com and ordered it as a trial. If you're an Excel 2000 user who writes a lot of VBA code, this book is the reference I recommend. There are some reviews here that complain about the format of this book not matching other Wrox publications and being harder to use. That may be true - I haven't used other Wrox publications - but I found everything I needed and a few extras in here. It's not the only Excel 2000 VBA reference I have on my shelf - check out Microsoft Excel 2000 Power Programming with VBA by John Walkenbach and SAMS Teach Yourself Excel 2000 Programming in 21 Days by Matthew Harris - they're both good references as well.
Rating: 
Summary: "Pass this book and buy something else"
Review: 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. It is not a book for self-starters.
Rating:
Summary: Seems like it is missing some basics
Review: 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. I think I needed more upfront information about where the code needs to go in the Visual Basic Editor, do I tie it to a sheet, the application or what. The index is also a little weak.
Rating: 
Summary: Answer all your basic needs when writing a VBA program
Review: I recently changed from Lotus (in which I developed applications in macros) to Excel 97.This book allows me to answer almost all my questions when writing macros in Excel. The examples gave me a leap in the time to develop an application. If I have to buy only one book to help me write Excel VBA macros, this is the book to buy. The only items to be improved is the index, which should be expanded and the font, which for me is too small. The authors John Green, Stephen Bullen and Felipe Martins are excellent.
Rating:
Summary: Lifesaver
Review: 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. Well, I did actually, but it was because i went and got this book. At least on 3 seperate occasions, I read this book on the train to work, and found out something useful. 2 large reasons why this book was very effective:
It showed me things like using WithEvent declarations, how to use classes better, and neat stuff like building you own menus based on a spreadsheet. He even included a program that prints out all the botton faces in Excel 2000. Thats one reason. The other is that
it was my sole reference to VBA matters. At this contract site, they didn't have VBA help files installed on the computer. So the Object Model, and simple VBA programming tutorial included in the book were more than useful -- they saved me time, and maybe my buttocks too. Other selling points:
the authors style is easy to absorb also. the book is very portable, so it was easy to read on the crowded train.
the book just kinda looks cool to me
easy to read print
the book didn't try to teach me Excel at the same time
Rating:
Summary: Lifesaver
Review: 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. Well, I did actually, but it was because i went and got this book. At least on 3 seperate occasions, I read this book on the train to work, and found out something useful. 2 large reasons why this book was very effective:
It showed me things like using WithEvent declarations, how to use classes better, and neat stuff like building you own menus based on a spreadsheet. He even included a program that prints out all the botton faces in Excel 2000. Thats one reason. The other is that
it was my sole reference to VBA matters. At this contract site, they didn't have VBA help files installed on the computer. So the Object Model, and simple VBA programming tutorial included in the book were more than useful -- they saved me time, and maybe my buttocks too. Other selling points:
the authors style is easy to absorb also. the book is very portable, so it was easy to read on the crowded train.
the book just kinda looks cool to me
easy to read print
the book didn't try to teach me Excel at the same time
Rating:
Summary: If you're stuck with VBA, get unstuck. Buy this book.
Review: I've just started my Ph.D. and bought Excel 2000 VBA to help me get to grips with processing my data files. My first impression was of a book that is jam-packed with information, although the smallish typeface may be off-putting to some at first. My second impression was that John Green and his crew are a bunch of mind-readers. Every code sample seems to address exactly the sorts of problems that I had been pondering for the past month. This was my first book on VBA, and it has really opened up the topic for me. On the strength of it bought Word 2000 VBA by Duncan McKenzie (with which I am also very pleased).
Rating:
Summary: Excelent Value
Review: Many programmers are not satisfied that their programs work, but they also want to know if the techniques they employ are the most efficient, or if there is a better means of doing something. For those readers who want to make use of Excels sophisticated object model this is a great book to learn how to do it best. Just about every programming technique I have needed has been covered, allowing me to develop Excel applications written with efficient code that is FAST. John Green seems to stay one step ahead by pre-empting any questions the reader has, and all the points he covers are backed up with code. Often the author will give several alternative approaches to solving a particular task programmatically, and also explain which approach is more effective / efficient and why. Although some explanation of basic programming techniques are covered in the "Primer in Excel VBA" chapter, this book is probably best suited to readers who have some programming background (although you don't have to be a pro either). My one criticism is directed more at Wrox Press than John Green, and is the reason I have only given four stars not five. As has been already mentioned in other reviews, the index is very poor, and is little more than an extended Table Of Contents - a trait in common with other Wrox books I have read. Finding that "golden nugget" in this is a gold mine of information is very time consuming. For example, trying to find the section on the EVALUATE or CALLER methods from the index won't yield much success unless you already know that they are covered in "Chapter Three: The Application Object Model" - this is what you look up in the index - crazy! Finding other entries in the index is just impossible since they are not there. My suggestion is buy this book, but as you read it through for the first time, use a highlighter on any points that you think may be of significant interest.
Rating: 
Summary: Useful Portion is Short
Review: Pages 7-254 cover EXCEL and VBA. Pages 257-264 cover "international issues", which has a limited audience in the USA. Pages 289-321 deal with the VBE. Pages 345-630 are a listing of the EXCEL Object Model, which I find none too useful. Likewise, pages 665-695 list the VBE Object Model, again not too useful to me. This book can be compared to Kofler "Definitive Guide to EXCEL VBA", which is 776 pages of exposition and pages 777-834 a listing of the most useful parts of the EXCEL Object Model, ADO, MS forms, Office, Binder, Scripting, VBA and VBE. Thus, you get a much more extensive discussion of how things work and how things fit together than is found in Green (or in Walkenbach, for that matter). Kofler also deals with international issues here and there. However, Green is a lot cheaper, and sometimes its compactness makes it easier to find things. Bottom line: Buy Green first (cheapest), Kofler second and Walkenbach last
| 
