O'Reilly logo

Tricks of the Microsoft® Office Gurus 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

Chapter 11. Maximizing Office with VBA Macros

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

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