Chapter 39 -- Using Office Control Structures

Chapter 39

In the last chapter, you learned how to write Microsoft Office macros from scratch by using several essential keywords in the Microsoft Visual Basic for Applications programming language. In this chapter, you'll learn how to add logic and efficiency to your macros by writing conditional expressions, decision structures, and loops that manage the information in your documents. These skills will allow you to write macros that format selected text, display and change settings in Office applications, work with collections, manage tables, and open documents.