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

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

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