2Writing Your Own Macros

Letting VBA do all the work by recording your macros is an easy way to automate tasks, and it’s a technique you’ll use often. However, to get the most out of VBA you need to do some full-fledged programming, which means writing your own macros, either from scratch or by using a recorded macro as a starting point.

Why go to all that trouble? Here are just a few of the advantages you gain by doing this:

• If you make a mistake while recording ...

Get Business Solutions VBA for the 2007 Microsoft Office System now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.