A. Working with VBA Macros


Activating the Ribbon’s Developer Tab

Running a VBA Macro

Recording a VBA Macro

Working with the Visual Basic Editor

Office gurus know a secret that’s crucial for mastering any or all of the Office applications: There are things you can make a program do that are not available via the program’s interface (that is, its Ribbon commands and shortcut keys). To accomplish these extra tricks and techniques, you have to go under the program’s hood and use Visual Basic for Applications (VBA), the programming language that comes with the Office suite. You use VBA to build small sets of instructions called scripts, or, more commonly, macros. With these instructions, you can make the program perform multiple ...

Get Business Solutions Tricks of the Microsoft Office 2007 Gurus now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.