Chapter 26. Using Macros to Automate Routine Tasks

In this chapter

Getting Started with Macros

What Can You Do with a Macro?

Using the Visual Basic Editor

How Office Applications Store Macros

Recording Simple Macros

Troubleshooting Recorded Macros

Running Macros

Digitally Signing Macros You Create

Troubleshooting

Extra Credit: Getting Ready to Tackle VBA

Getting Started with Macros

Office macros are small computer programs that perform tasks on your behalf. And when we say small, we mean very small. A skilled programmer can create a macro that does something meaningful with just a few lines of program code, written in the underlying programming language of Office, Visual Basic for Applications (VBA).

Anyone can create powerful macros using tools ...

Get Special Edition Using Microsoft® Office Home and Student 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.