Chapter 26. Using Macros to Automate Office Tasks

In this chapter

Getting Started with Macros 802

What Can You Do with a Macro? 802

Using the Visual Basic Editor 804

Recording Simple Macros 806

Troubleshooting Recorded Macros 810

Running Macros 814

Managing Macros 814

Macro Security 816

Building Interactive VBA Programs 821

Code Snippets You Can Use 824

Troubleshooting 830

Extra Credit: Getting Ready to Tackle VBA 831

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

Get Special Edition Using Microsoft® Office 2003 Student-Teacher Edition 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.

Start your free trial