Holy Macro! It's 1,600 Excel VBA Examples

Author: Hans Herber, Bill Jelen
List Price: $89.00
Our Price: Click to see the latest and low price
ISBN: 0972425810
Publisher: Holy Macro! Books (30 September, 2002)
Sales Rank: 342,751
Average Customer Rating: 4 out of 5

Customer Reviews

Rating: 4 out of 5
Excel translates better than German
Good collection of workable macro ideas but beware there is a fair smatterring of untranslated German scraps throughout the samples both in the worksheets and the VBA code.

Most of the differences are idiomatic translation - example the index says: "How can I call a Macro depending on how long the Workbook has been open?" when the real translation is "How can I call a Macro depending on what time the Workbook is opened".

As the VBA code started life in German a number of code samples use German language words as variable names making it a liitle difficult at time to decipher the meaning.

The CD is easy to use but lacks an install to Hard-disk option for the frequent user but that should prove litle challenge for the level of intellect for users likely to access the code.

The code is well laid out and every module is in a separate workbook allowing simple testing and exploration of the idea. Very few of the samples failed to run as promised and most failures relate to version differences in Excel particularly with those who have already migrated to XP - and then its mainly in the samples that use various email techniques or are affected by security levels in the users Excel.

Biggest plus is the cut and paste ability as the modules are laid out well and would satisfy the requirements of the strictest code cutter.

I keep going back to it and am gradually building up a better list of what each sample really does - I guess it was hard to find a translator who was as good at translation as Excel and VBA which is the only detraction from an otherwise great product!

Similar Products

Mr Excel ON EXCEL: Excel 97, 2000, 2002


Book Index