VBA and Macros for Microsoft Excel (Business Solutions) (Paperback)

by Bill Jelen (Author), Tracy Syrstad (Author) "Visual Basic for Applications combined with Microsoft Excel is probably the most powerful tool available to you..." (more)
Key Phrases: default action from taking place, embedded chart events, many unique customers, Private Sub, Error Resume Next, Range Dim (more...)

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. You'll also be able to download 4 MB of sample spreadsheets, project files and code from the publisher's Web site. Written by the principal behind the leading Excel Web site, Mrexcel.com, this book is sure to save you time and money!

About the Author

Bill Jelen "Mr. Excel" is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company.

Tracy Syrstad works as an Excel and Access Consultant. As part of the Mr.Excel.com Consulting team, she has helped develop VBA solutions for clients around the world. She remembers the painful trek up the VBA learning curve while developing applications for co-workers at a former job. She is co-editor of Holy Macro!, it¿s ֿ,600 Excel VBA Examples CD” and editor of Dreamboat On Word.

Product Details

• Paperback: 576 pages
• Publisher: Que (May 20, 2004)
• Language: English
• ISBN-10: 0789731290
• ISBN-13: 978-0789731296
• Product Dimensions: 9 x 7.4 x 1.3 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars See all reviews (18 customer reviews)
• Amazon.com Sales Rank: #276,412 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #66 in

  Books > Computers & Internet > Microsoft > Development > VBA

Customer Reviews

Most Helpful Customer Reviews

39 of 42 people found the following review helpful:

5.0 out of 5 stars Excellent VBA Resource, and I've seen them all!, July 21, 2004

By	Anne M. Troy (Quakertown, PA) - See all my reviews (REAL NAME)

I have never been able to grasp the concepts of VBA. I believe in VBA and its ability to supercharge Office applications, but could never seem to learn even Excel VBA, which is supposed to be the easiest. This is the first book I've read (yes, I've read the Romans and the Walkenbachs) that made any sense to me at all. Too many books approach VBA as if you have already learned how to code in other programs. I came to VBA from the Office user side of things. I don't have that *programming* brain required to pick up VBA easily. So this book has been a godsend. While I've only read about half the book so far, so many things that escaped me are finally falling into place. Thanks very much to Bill and Tracy for a terrific VBA resource!

16 of 17 people found the following review helpful:

5.0 out of 5 stars Excellent for all, May 15, 2005

By	Jimmy Hai (Manchester, CT USA) - See all my reviews (REAL NAME)

This book is an excellent resource for all levels. The book contains some minor typo and error in the code but you can download all the correct code files from the publisher's website. If you keep working along with book, you will soon be able to create macro (or modify the book's macro) that save you hours of time. I highly recommend reading Chapter 14: Reading from and Writing to the web. It contains code that you can extract data from the web, it is also the main reason why I bought this book.

17 of 19 people found the following review helpful:

3.0 out of 5 stars Somewhat disjointed, June 24, 2006

By	B. Gehring - See all my reviews (REAL NAME)

The first few chapters were a reasonable introduction to VBA for Excel, but after that, the examples, while being quite relevant and useful, seemed somewhat random, and did not strike me as being well supported by the text.

I think that those who are looking for an abundance of code examples will be reasonably happy. The book is full of code handling tasks that most Excel VBA programmers will need to find solutions to. Those looking for a tutorial, for examples of good coding practice and principles, and an understanding of the underlying principles of VBA in the Excel environment, should probably look elsewhere.

Walkenbach's Power Programming is excellent. VBA for Modelers, by Albright, is a book that does a great job of combining theory and practical code examples for me. For people looking for advanced material, Excel with VBA & .NET by Jeff Webb, and Professional Excel Developement by Bullen, Bovey and Green are very good.