1Creating and Running Recorded Macros

This book is about programming, but for certain tasks you may not need to do any programming at all. That’s because VBA in Word and Excel lets you create a macro automatically by recording a set of steps you perform in the program. (Unfortunately, the other programs in the 2007 Office suite don’t have macro recording capabilities.) This is by far the easiest way to create a macro. With this method, you start the macro recording feature and then run through the operations you want to automate—which can include selecting text, running commands from the Ribbon (the Office 2007 replacement for the menus and toolbars in previous versions ...

Get Business Solutions VBA for the 2007 Microsoft Office System 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.