Mastering VBA 6 [Paperback]

Guy Hart-Davis (Author)

Product Details

• Paperback: 752 pages
• Publisher: Sybex (January 21, 2000)
• Language: English
• ISBN-10: 0782126367
• ISBN-13: 978-0782126365
• Product Dimensions: 9 x 7.5 x 1.9 inches
• Shipping Weight: 2.8 pounds
• Average Customer Review: 3.4 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #2,146,677 in Books (See Top 100 in Books)

More About the Author

I'm now writing a free e-mail newsletter called The Useful Geek (website above).

I'm updating my iPod book to cover the latest features, the latest iPods... and the iPhone when it arrives

I'm also writing a book called Do-It-Yourself PC Upgrade Projects, which shows you 24 ways to get more out of your computer -- without buying a new computer. (Or not yet...)

Happy reading -- and computing!

Customer Reviews

Most Helpful Customer Reviews

49 of 49 people found the following review helpful:

5.0 out of 5 stars Excellent book for beginners/nonprogrammers, February 21, 2003

By 

"inkster68" (St. Louis, MO) - See all my reviews

This review is from: Mastering VBA 6 (Paperback)

Have read the other reviews, and feel the need to counter a few points. This is a great book for nonprogrammers who are proficient with an application such as Word or Excel and want to take the next step to getting their application to "jump through hoops." (Or who just want to get a taste for programming.)

Background: I'm a tech writer with no programming education or experience other than some minor html and scripting I've picked up on the job. This book enabled me to self-educate myself to a fairly proficient level with VBA in a matter of two months. Out of all the "learn this skill quick" books that I've bought, this one has delivered the most value by far.

A few counterpoints: The reader from Naskayuna says the author spends pages discussing techniques that can be found in any other book. Those pages of discussion are what make this book invaluable to a beginner. Every code example the author gives (I didn't count, but I'd say there are scores) is followed by a thorough, step-by-step explanation of what each line of code means.

For the experienced programmer (apparently this reviewer is one), this probably gets old. But for the inexperienced user it does several things. Your confidence goes up each time you can look at a coded procedure and understand everything that is happening from the first step to the last. Your VBA lessons get driven in by repetition. And you don't spend as much time flipping back trying to locate previous concepts, because the code you are looking at is explained right there. I own another VBA book and have checked out two others from my employer's training library. There is no comparison! This author's approach to explaining sample code is by far the best for VBA novices without a programming background.

The reader from Walnut CA complained that there weren't enough examples and that the first 100 pages offer only an agonizing explanation of all the menu components in the VBA editor. The reviewer is basically right about the first 100 pages, but missed a very important point. My experience differed in that I read some of the introductory stuff up front, then skipped right over most of those 100 pages to dive into the practical, hands-on stuff. Then I just used the first 100 pages or so as a resource when I needed to know more about how something worked. In fact, I think the author actually recommends this strategy early in the book! It worked like a charm for me. Maybe the reviewer didn't get past the first 100 pages, because if there's one thing this book definitely does NOT lack, it is hands-on examples.

Last counterpoint: The first reviewer (March 2000) says there's a lot of stuff you won't see here. I don't think it's possible in a single book to cover all the concepts of a huge topic like VBA and still give plenty of hands-on practice. I liked the balance of conceptual explanations and hands-on practice. I also liked the fact that the author spends a lot of time telling you how to get help beyond the book. He spends pages explaining how best to use the online help. He may not cover everything, but he points you toward plenty of other tools that will fill the gaps.

Some caveats: Learning VBA on your own from a book is somewhat akin to learning a foreign language using only audiotapes and a textbook. It might not be for everybody. I give this book five stars, but it ain't a magic bullet!! This book worked for me because I was already proficient with a particular tool (MS Word) and had some specific goals in mind for what I wanted to accomplish with VBA, and was willing and able to put in a lot of time at the computer to meet those goals. If you don't have a tool and some goals of your own in mind, or don't have the time to devote to learning this stuff, your mileage may vary. But if you've got all that going for you, I don't think you'll find a better starting point than this.

10 of 10 people found the following review helpful:

2.0 out of 5 stars A book for very patient beginners, September 21, 2001

By 

"rrojasg" (Walnut, CA USA) - See all my reviews

This review is from: Mastering VBA 6 (Paperback)

I expected much more from this book, specially if its title says "Mastering." Although the author claims he will be hands-on and practical, in fact he elaborates on only few examples preceeded by interminable explanations. For example, the first 100 pages contain only 4 very simple and concrete cases using macros and the rest is an agonizing explanation on each and all of the components of several menus. No concrete examples that would enable the reader to cement his knowledge on solid ground.
On ocassions the author explains VBA for an specific application, say Word, but then he changes to give general explanations for all applications at once, disorderly mentioning exceptions for Excel, Word, Project or PowerPoint, what makes the reading difficult.
No, this book is not for me. I need principles and theory handsomely applied in concrete cases.

5 of 5 people found the following review helpful:

3.0 out of 5 stars For the non programmer, May 28, 2002

By A Customer

This review is from: Mastering VBA 6 (Paperback)

This book should be called "Programming 101 with VBA". The author spends pages discussing inefficient sorts and searches that can be found in any other book.

If you don't know anything about programming, and what to know how to get the most of your applications - this may be for you.
Don't buy this if you already know VB and want to learn some of the andvanced features of VBA.