• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part III: Office 2003 Customization Tricks > Maximizing Office with VBA Macros

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 the program perform multiple tasks in a single operation or, as I mentioned earlier, perform tasks that aren’t part of the interface. For example, in Chapter 1, “Building Dynamic Documents in Word,” I showed you a simple macro that updates all the fields in a document (see Listing 1.1), a task that is otherwise cumbersome to accomplish using traditional methods.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint