O'Reilly logo

Business Solutions VBA for the 2007 Microsoft Office System by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required