| VBA and Macros for Microsoft Excel |  | Authors: Bill Jelen, Tracy Syrstad
Publisher: Que
Category: Book
This item is no longer available
Rating:  5 reviews
Media: Paperback
Pages: 576
Shipping Weight (lbs): 2.1
Dimensions (in): 9.1 x 7.4 x 1.3
ISBN: 0672326507
EAN: 9780672326509
ASIN: 0672326507
Publication Date: May 10, 2004
|
| Also Available In:
|
| Similar Items:
|
| Customer Reviews:
 Should include FREE magnifying glass ! January 2, 2009
I've just started this book, and so far it seems well-suited to my needs (as a complement to and hopefully a next step up from "For Dummies") but there is one BIG problem :
all screen prints in the book have acres of white space all around them and so are consequently only 8 cm wide !(to portray what would be 40cm wide on your screen). This is OK for some simple dialog boxes, but when it comes to the fullscreen dumps of the VBA Help etc, then this is just plain UNREADABLE). As a result you have to open up Excel and look at it onscreen. OK, so this is far from impossible most of the time, but it doesn't allow the book to be read on the train !
PS. ...and it just got worse! I've only reached page 55 (out of 500+) and one of the first examples of code given in the book is wrong ("Row.Count" instead of "Rows.Count") so the code won't run in the given form.
P.P.S but I'm still ploughing through it and it IS rather good. Not only all the theory you need, but also lots of great examples that can easily be adapted to most people needs. (Can't seem to be able change the above rating to 4 stars.)
 Could do better December 27, 2007
1 out of 1 found this review helpful
This book spends too much time giving you "cool" examples "to impress your clients" and not enough time explaining the syntax of the language. Also, the book does assume a little more in the way of programming knowledge than it claims, e.g. use of DIM statement is never explained.
All I wanted from a VBA manual was a dry, comprehensive syntax/semantics-oriented guide. What this book does is give small examples of what individual properties can do, then build these up into 'useful' macros. The problem is that if you want to write some code slightly different to the example given in the book, it takes a lot of digging to find out how.
Hard Going November 12, 2006
3 out of 6 found this review helpful
If you are a bit dim like me you are going to struggle with this book, but persistance pays off. It does eventually sink in.
 An excellent buy. Far more useful than those 500+ page "everything about..." tomes June 9, 2006
8 out of 8 found this review helpful
This is one of those rare things, a technical "how to" book that actually delivers more than it claims on the cover. It is unintimidating, easy to read, and there's a really useful nugget of information on almost every page. As an example, although ostensibly focused only on Excel Macro programming, this book along the way clarifies some critical details on both Excel Pivot Tables and R1C1 cell referencing that another 850-page "comprehensive" book on Excel completely failed to mention.
VBA & Macros for Excel July 23, 2004
37 out of 42 found this review helpful
Mr Excel has written yet another great book about Excel, over 500 pages of highly informative stuff, great examples and its all written in an easy to use format.(The explanation of VBA speech is great.)As a Excel power user for several years I'm always looking for something to give me the edge and make mine or my co-workers life that little easier. This book does, as do the rest of the Mr Excel / Holy Macros titles. Want to learn VBA - Go Buy!!
|
|
|
Site powered by Amazon.co.uk | |