If you create Excel Macros in your job there are 3 important ways you can improve
1.Build the Macros in less time
2.Make the Macros run faster
3.Reduce the number of errors in the Macros
This book can help you achieve all three. It contains 41 time tested principles for improving the Macros you create. These techniques are used by the top professionals to create top quality VBA code. If you adopt these principles as your habits you will improve you Macro skills in a very short time. Most of the habits are simple to use and you will see the results immediately.
They include
1.Ways to check a file exists before you try and open it
2.Turning off certain Excel functionality so you Macros run much faster
3.An easy method for deciding which of the 7 VBA Loops is best to use
4.How to read a large set of data into an Array using just one line of code!
5.A simple logger you can use right now to record users and errors
6.Why Debug.Assert is worth its weight in solid gold
and much much more.
1.Build the Macros in less time
2.Make the Macros run faster
3.Reduce the number of errors in the Macros
This book can help you achieve all three. It contains 41 time tested principles for improving the Macros you create. These techniques are used by the top professionals to create top quality VBA code. If you adopt these principles as your habits you will improve you Macro skills in a very short time. Most of the habits are simple to use and you will see the results immediately.
They include
1.Ways to check a file exists before you try and open it
2.Turning off certain Excel functionality so you Macros run much faster
3.An easy method for deciding which of the 7 VBA Loops is best to use
4.How to read a large set of data into an Array using just one line of code!
5.A simple logger you can use right now to record users and errors
6.Why Debug.Assert is worth its weight in solid gold
and much much more.
