VBA and Macros for Microsoft Excel (Business Solutions) | 
 enlarge | Authors: Bill Jelen, Tracy Syrstad
Publisher: QUE
Category: Book
List Price: £28.99
Buy New: £13.99
You Save: £15.00 (52%)
New (31) Used (6) from £13.99
Avg. Customer Rating:  5 reviews
Sales Rank: 12695
Media: Paperback
Number Of Items: 1
Pages: 576
Shipping Weight (lbs): 2.2
Dimensions (in): 9 x 7.4 x 1.3
ISBN: 0789731290
Dewey Decimal Number: 005.54
UPC: 029236731298
EAN: 9780789731296
ASIN: 0789731290
Publication Date: May 20, 2004
Availability: Usually dispatched within 1-2 business days
Shipping: Expedited shipping available
Shipping: International shipping available
Condition: Ships via priority mail within 1 business day. Transit time is 7-14 days. We are a well known, high volume US seller with an excellent rating and professional service.
|
| 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!!
|
|
|
