VBA and Macros for Microsoft Excel (Business Solutions) |  | Authors: Bill Jelen, Tracy Syrstad
Publisher: QUE
Category: Book
List Price: £28.99
Buy New: £10.00
as of 30/7/2010 16:05 EDT details
You Save: £18.99 (66%)
New (23) Used (11) from £9.50
Seller: Anaheim
Rating:  5 reviews
Sales Rank: 27715
Media: Paperback
Edition: 1
Pages: 576
Number Of Items: 1
Shipping Weight (lbs): 2.1
Dimensions (in): 9.1 x 7.3 x 1.3
ISBN: 0789731290
Dewey Decimal Number: 005.54
UPC: 029236731298
EAN: 9780789731296
ASIN: 0789731290
Publication Date: May 10, 2004
Availability: Usually dispatched within 1-2 business days
| |
| Features:
| • | New | | • | Mint Condition | | • | Dispatch same day for order received before 12 noon | | • | Guaranteed packaging | | • | No quibbles returns |
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
A thorough introduction to programming macros with Microsoft Excel and VBA.
|
| Customer Reviews:
 Should include FREE magnifying glass ! January 2, 2009
P. Maley (paris)
3 out of 4 found this review helpful
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.
...and nothing at all on "Data Types" (long, integer etc)
P.P.P.S but I'm still ploughing through it and it IS rather good. Not just plenty of theory, 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
Business Analyst (London)
3 out of 4 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
Andy (Lerwick, Shetland United Kingdom)
4 out of 8 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
colin_e (Nr. Reading, UK)
13 out of 14 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
39 out of 46 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!!
|
|
|
