Customer Reviews

10
4.2 out of 5 stars
5 star
6
4 star
0
3 star
4
2 star
0
1 star
0
Your rating(Clear)Rate this item


There was a problem filtering reviews right now. Please try again later.

Showing 1-4 of 4 reviews(3 star)show all reviews
7 of 7 people found the following review helpful
on 2 January 2001
This book does have some very useful parts - e.g. the chapter on international settings - though even there the problem with failure to recognise a number input as % is repeated mentioned, but no workaround is proposed. There are some useful tips on gotchas. I found it very light in dealing with User Defined Functions - no indication as to how to create and use a function that returns an array result, or how to programme function help for the user trying to understand the arguments and purpose of a function for instance. Also no coverage of using compiled .dll for additional speed in computationally intensive tasks, and how to pass data to and fro to those.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
3 of 3 people found the following review helpful
on 4 October 2002
This book should be the answer to many a programmer's prayers. There is a little of everything in here and you'll certainly learn a bit simply by reading it. One for the bookshelf? Well yes, in addition to several other texts, but then there are no books I know of in the XL world that can stand alone and yes I've bought a copy. (In the XL world there simply isn't the equivalent of the books by Getz, Litwin et al for Access and most fall far short.)
Summit:
The encyclopaedic Chapter 2 "The primer" is an excellent educational tool. It's very important in XL, like everywhere else, to learn how to program decent code. However one doesn't generally have the baby-walker that is "Record Macro" facility from where many a nipper (including this reviewer) set out on the quest for Excel mastery. But the time eventually comes when one has to learn to walk properly and this chapter alone is a valuable contribution to anyone seeking to throw away the crutches of the early toddler years.
Sink:
The index is horrible since pre-assumes a prior knowledge of the xl object model - one simple example...to find out about the cells (property) don't look in C look in R - because as you will know the Cells property is a property of the Range object. Since everyone knows this - this is fine - however as you approach the boundaries of your knowledge (as you will if you're learning anything) such a set up is frustrating.
-Verdict: Excellent book, but mistitled - should read Excel 2000 VBA - a primer. And a fine primer it is too! (But don't annoy yourself by trying to learn a la help file using reference indexes though and you'll like the book a lot.)
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful
on 25 July 2002
For an experienced VBA programmer, this book probably offers relatively little. The introduction claims it's aimed at all levels, but as a near-beginner I found it WAY too skimpy. I still can't follow how to set up a user form from code in a way that actually works. The authors grapple well with the sheer complexity and lack of logic of the object-oriented approach to writing code, but many more painstaking examples and step by steps are needed to make the whole thing truly clear.
On balance the book is almost certainly at its best for the reader with middle-of-the-road VBA experience: there are many useful hints for writing code that runs much faster (and is shorter) than the traditional "select range and operate" approach that results from recording macros in Excel.
Regrettably the book hasn't solved any of my own problems I hoped it would. Downloading the selection of macros from the Wrox website hasn't helped either.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Almost half of the 700 pages are taken up by two huge appendices documenting stuff you can generally get from the help files. Not only is it light on ODBC it doesn't even mention MSquery. Again like most of it's competition there is scant attention paid to compatibility issues with previous versions although it does consider cross platform issues for Mac's and PC's in places.
I found the writing style clear and to the point but lacking real in-depth detail, ignoring the volumous appendices. No CD-ROM seems a little cheap, but then it's relatively inexpensive and you can download source code from their website.
0CommentWas this review helpful to you?YesNoSending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Send us feedback

How can we make Amazon Customer Reviews better for you?
Let us know here.

Sponsored Links

  (What is this?)
  -  
Instant Excel Help, Without Hiring. Excel Talent Starting At $60/hr.
  -  
Automation, custom programs, data mgmt & reports for Small Businesses
  -  
Automation, Macros, and More! Get A Free Quote, Get Started Today