Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need [CD-ROM]

Hans Herber (Author), Bill Jelen (Author), Tom Urtis (Author)

Book Description

Publication Date: April 1, 2006

This guide to unleashing the power of Microsoft Excel by using Excel's VBA programming language shows nonprogrammers how to solve real-life problems with Excel VBA. Thousands of concise code samples are accompanied by sample workbooks in a question-and-answer format that describes each specific task.

Editorial Reviews

About the Author

Hans Herber runs Germany's leading Excel website, www.herber.de, and is author of several German language resources on Microsoft Excel. Bill Jelen is the principal of MrExcel.com and the author of Mr. Excel on Excel. He lives in Uniontown, Ohio. Tom Urtis owns Atlas Programming Management—a Microsoft Office, VBA, and business management consulting corporation. He lives in Cupertino, California.

Product Details

• CD-ROM: 2500 pages
• Publisher: Holy Macro! Books (April 1, 2006)
• Language: English
• ISBN-10: 1932802185
• ISBN-13: 978-1932802184
• Product Dimensions: 5 x 5.8 x 0.4 inches
• Shipping Weight: 2.4 ounces (View shipping rates and policies)
• Average Customer Review: 3.0 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #82,451 in Books (See Top 100 in Books)
  • #7 in Books > Computers & Technology > Microsoft > Spreadsheets
  • #18 in Books > Computers & Technology > Microsoft > Development > VBA

More About the Author

I spent twelve years 'in the trenches', working as a financial analyst for finance, accounting, marketing and operations departments of a $500 million company. Armed with a half-rate reporting tool and a spreadsheet, I was responsible for turning large amounts of data into analyses for the board room quickly and accurately. Working originally in Lotus 1-2-3 and then Microsoft Excel, I honed techniques to take massive amounts of data and produce meaningful reports in record time. These techniques are spelled out in Guerilla Data Analysis Using Microsoft Excel.

In 1998, I launched MrExcel.com, which is now one of the three most popular Excel websites with 21 million annual page views. Being MrExcel is now my full-time gig. My team has developed custom applications for hundreds of clients around the world. I enjoy entertaining a room full of accountants with my 'Power Excel' seminar.

When I am not Excelling, you can find me and the family under the stars enjoying a movie at one of the many drive-in theaters that still dot northeast Ohio or kayaking on the Mogadore Resevoir.

Customer Reviews

Most Helpful Customer Reviews

4 of 6 people found the following review helpful:

3.0 out of 5 stars Macro CD - Definately helps and good start but could be more user friendly, September 17, 2007

By 

FPFlorida - See all my reviews

This review is from: Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need (CD-ROM)

I think the CD definately helps you identify macros for very particular, obsscure uses however you still need to customize the macro for your file. Sometimes this isn't so easy - I think the CD needs to be more user friendly in terms of explaining howe to use the code they have in your file. Definately though one of the better macro products on the market - there just isn't enough good advanced products in this market.

1.0 out of 5 stars Holy Macro - Its 2500 "Not Very Good" examples, October 30, 2011

By 

Gaz_Allan - See all my reviews

Amazon Verified Purchase

This review is from: Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need (CD-ROM)

I was actually quite disappointed with this CD and wished I hadn't purchased this at all. I previously purchased Bill Jelen's VBA live lessons and thought it was the best tutorial that I had seen. A lot of VBA books and instructions go from very simple, how to loop or how to reference a cell to advanced code that is very difficult to follow which is hard to replicate for you own use. This was the first time that I had seen an instructional video that gave useful examples and explained the logic behind the process. I am also a subscriber to MrExcel and ExcelifFun which are excellent. This is why I was so shocked that this CD was so poor.

These examples in "Holy Macro" looked to be very old and often use code that by Bill Jelen's mouth, should never use like the looping method of using Loop - Wend. When I received the CD, I spent about an hour looking through the examples to see if there was something I could possibly use, or use the logic to adapt the code to my work. Unfortunately I was disapointed with the whole layout and probably wont insert the CD into my computer again.

Once bitten twice shy so will be very careful when buying my next purchase.

1 of 2 people found the following review helpful:

4.0 out of 5 stars Holy Macro 2500, November 1, 2011

By 

Jamil - See all my reviews

Amazon Verified Purchase

This review is from: Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need (CD-ROM)

I did not expect what was in the disk when i received it. it is amazing. you have got whatever code you need. Now having this product, i do not have to google and search for customized VBA codes, i have got all i need. just to highlight that this product helps if you are familiar with knowledge on how to use VBA. otherwise for complete beginner they have to first learn VBA then they can find this product useful.