VBA and Macros for Microsoft Excel (Business Solutions) | 
 enlarge | Authors: Bill Jelen, Tracy Syrstad
Publisher: Que
Category: Book
List Price: $39.99
Buy New: $22.95
You Save: $17.04 (43%)
New (35) Used (17) from $16.59
Rating:  17 reviews
Sales Rank: 57707
Media: Paperback
Pages: 576
Number Of Items: 1
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 ships in 1-2 business days
Shipping: Expedited shipping available
Condition: *** N E W *** FREE online tracking *** Fast Shipping !!!
| |
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site, www.mrexcel.com, this book is sure to save you time and money!
|
| Customer Reviews: Read 12 more reviews...
 Run the other way...quickly!! July 2, 2008
Michael Ryan (Austin, Texas USA)
2 out of 4 found this review helpful
If I could give 0 stars, I would.
This book is poorly written and poorly edited...and I have the version "Reprinted with corrections." Flipping through it in the bookstore, it seemed promising - enough so that I actually bought it. After three chapters, however, I am ready to throw in the towel.
This is a technical book. It's about programming. It contains examples of actual code. The examples have to be correct to have any credibility. Once you lose that, every line becomes suspect. Let me provide you just a few examples.
On page 32, the colorindex for "yellow" is given as "6"; on page 33 it is "30".
On page 41, "Selection is actually a property and not an object." When I reach page 50, "Selection" has become an object again.
On page 62, in the third example within Table 3.1, the delimiting comma is inside the quotes.
On 67, " Notice that that the offset..."
Also on that page, the resizing example at the bottom is wrong. If I have a column and add two more to it, I end up with three. Maybe Mr. Excel is using a higher level of math when he says "Range("Produce").Resize(,2) and says "Remember, the number you resize by is the TOTAL number of rows and/or columns you want to include."
What really rolled my eyes back in my head was on page 63, when I encountered .range(.range, range) with insufficient introduction. A relatively simple statement with a single range reference suddenly morphed into a triple range reference with an indecipherable comment about "an extra range at the beginning of the code line." This makes absolutely no sense, and coupled with the authoring or editing miscues mentioned earlier, it is not even possible to determine if this is a typo or simply a badly written passage.
Whether I ultimately can gain any value from this book remains to be seen - assuming I am able to actually make sense of the content. For me, it was a total waste of the purchase price.
 The best book on the subject September 29, 2007
Ayman Mikhail (San Diego, CA USA)
1 out of 3 found this review helpful
Bill Jelen is a brilliant self-promoter. His book is even more brilliant. His newsgroup, MrExcel Message Board Forum at www.mrexcel.com, is an invaluable resource.
happy transaction September 15, 2007
Wen Ni Yeoh
0 out of 3 found this review helpful
I am very satisfied with the transaction. The shipment was on time and the product is in good quality
Useful July 12, 2007
Alfredo Lattero (Grl Pacheco, Buenos Aires, Argentina)
1 out of 1 found this review helpful
The book is useful. The worksheets downloaded from the Internet are also very clear.
Sometimes you expect more explanations on statements which use new features not connected with the subject being reviewed.
I think that I shall not need to purchase any other book on this subject.
Impressive! A wealth of key information and examples October 3, 2006
T. Phan (Miami, FL)
5 out of 5 found this review helpful
I found this book to be one of the best references for Excel VBA development. The book is easy to understand and follow. Contains a large amount of examples that can be easily understood. Addresses many critical aspects of excel VBA development. Not too much was spent on forms/GUI development so you will have to look elsewhere if you into that. Also addresses interfacing Excel to databases using ADO as well as API programming which is critical for superusers to extend the power of excel without the limitation of data storage. Overall, the authors have a superb job and I consider this book to be an essential of my Excel VBA library!
|
|
|
