Tricks of the Microsoft® Office Gurus

Chapter 11. Maximizing Office with VBA Macros

IN THIS CHAPTER

• Using a VBA Macro

• Recording a VBA Macro

• Working with the Visual Basic Editor

• Working with Macros

• VBA Programming Basics

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 menu commands, toolbar buttons, 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 ...