Mastering VBA for Microsoft Office 2007 -- Acknowledgments -- About the Author -- Contents at a Glance -- Contents -- Introduction -- Part 1: Recording Macros and Getting Started with VBA -- Chapter 1: Recording and Running Macros in the Microsoft Office Applications -- What Is VBA and What Can You Do with It? -- Understanding Macro Basics -- Recording a Macro -- Running a Macro -- Recording a Sample Word Macro -- Recording a Sample Excel Macro -- Assigning a Way of Running the Macro -- Deleting a Macro -- The Bottom Line -- Chapter 2: Getting Started with the Visual Basic Editor -- Opening the Visual Basic Editor -- Using the Visual Basic Editor's Main Windows -- Setting Properties for a Project -- Customizing the Visual Basic Editor -- Closing the Visual Basic Editor and Returning to the Host Application -- The Bottom Line -- Chapter 3: Editing Recorded Macros -- Testing a Macro in the Visual Basic Editor -- Editing the Word Macro -- Editing the Excel Macro -- Editing a PowerPoint Macro -- The Bottom Line -- Chapter 4: Creating Code from Scratch in the Visual Basic Editor -- Setting Up the Visual Basic Editor for Creating the Procedures -- Creating a Procedure for Word -- Creating a Procedure for Excel -- Creating a Procedure for PowerPoint -- Creating a Procedure for Access -- The Bottom Line -- Part 2: Learning How to Work With VBA -- Chapter 5: Understanding the Essentials of VBA Syntax -- Getting Ready -- Procedures -- Statements -- Keywords -- Expressions -- Operators -- Variables -- Constants -- Arguments -- Objects -- Collections -- Properties -- Methods -- Events -- The Bottom Line -- Chapter 6: Working with Variables, Constants, and Enumerations -- Working with Variables -- Working with Constants -- Working with Enumerations -- The Bottom Line -- Chapter 7: Using Array Variables -- What Is an Array? -- Declaring an Array.

Storing Values in an Array -- Multidimensional Arrays -- Declaring a Dynamic Array -- Redimensioning an Array -- Returning Information from an Array -- Erasing an Array -- Finding Out Whether a Variable Is an Array -- Finding the Bounds of an Array -- Sorting an Array -- Searching Through an Array -- The Bottom Line -- Chapter 8: Finding the Objects, Methods, and Properties You Need -- What Is an Object? -- Working with Collections -- Finding the Objects You Need -- Using Object Variables to Represent Objects -- The Bottom Line -- Part 3: Making Decisions and Using Loops and Functions -- Chapter 9: Using Functions -- What Is a Function? -- Using Functions -- Using Functions to Convert Data from One Type to Another -- Using Functions to Manipulate Strings -- Using VBA's Mathematical Functions -- Using VBA's Date and Time Functions -- Using File-Management Functions -- The Bottom Line -- Chapter 10: Creating Your Own Functions -- Components of a Function -- Creating a Function -- Examples of Functions for Any VBA-Enabled Application -- Creating a Function for Word -- Creating a Function for Excel -- Creating a Function for PowerPoint -- Creating a Function for Access -- The Bottom Line -- Chapter 11: Making Decisions in Your Code -- How Do You Compare Things in VBA? -- Testing Multiple Conditions by Using Logical Operators -- If Statements -- Select Case Statements -- The Bottom Line -- Chapter 12: Using Loops to Repeat Actions -- WhenShould You Use a Loop? -- Understanding the Basics of Loops -- Using For...Loops for Fixed Repetitions -- Using Do...Loops for Variable Numbers of Repetitions -- While...Wend Loops -- Nesting Loops -- Avoiding Infinite Loops -- The Bottom Line -- Part 4: Using Message Boxes, Input Boxes, and Dialog Boxes -- Chapter 13: Getting User Input with Message Boxes and Input Boxes -- Opening a Procedure to Work On.

Displaying Status BarMessages in Word and Excel -- Message Boxes -- Input Boxes -- Forms: When Message Boxes and Input Boxes Won't Suffice -- The Bottom Line -- Chapter 14: Creating Simple Custom Dialog Boxes -- When Should You Use a Custom Dialog Box? -- Creating a Custom Dialog Box -- Linking a Dialog Box to a Procedure -- Retrieving the User's Choices from a Dialog Box -- Examples of Connecting Dialog Boxes to Procedures -- Using an Application's Built-in Dialog Boxes from VBA -- The Bottom Line -- Chapter 15: Creating Complex Dialog Boxes -- Creating and Working with Complex Dialog Boxes -- Using Events to Control Forms -- The Bottom Line -- Part 5: Creating Effective Code -- Chapter 16: Building Modular Code and Using Classes -- Creating Modular Code -- Creating and Using Classes -- The Bottom Line -- Chapter 17: Debugging Your Code and Handling Errors -- Principles of Debugging -- The Different Types of Errors -- VBA's Debugging Tools -- Dealing with Infinite Loops -- Dealing with Runtime Errors -- Suppressing Alerts -- Handling User Interrupts in Word, Excel, and Project -- Documenting Your Code -- The Bottom Line -- Chapter 18: Building Well-Behaved Code -- What Is a Well-Behaved Procedure? -- Retaining or Restoring the User Environment -- Leaving the User in the Best Position to Continue Working -- Keeping the User Informed during the Procedure -- Making Sure the Procedure Is Running under Suitable Conditions -- Cleaning Up after a Procedure -- The Bottom Line -- Chapter 19: Securing Your Code with VBA's Security Features -- Understanding How VBA Implements Security -- Signing Your Macro Projects with Digital Signatures -- Choosing a Suitable Level of Security -- Locking Your Code -- The Bottom Line -- Part 6: Programming the Office Applications -- Chapter 20: Understanding the Word Object Model and Key Objects.

Examining the Word Object Model -- Working with the Documents Collection and the Document Object -- Working with the Selection Object -- Creating and Using Ranges -- Manipulating Options -- The Bottom Line -- Chapter 21: Working with Widely Used Objects in Word -- Using Find and Replace via VBA -- Working with Headers, Footers, and Page Numbers -- Working with Sections, Page Setup, Windows, and Views -- Working with Tables -- The Bottom Line -- Chapter 22: Understanding the Excel Object Model and Key Objects -- Getting an Overview of the Excel Object Model -- Understanding Excel's Creatable Objects -- Working with Workbooks -- Working with Worksheets -- Working with the Active Cell or Selection -- Working with Ranges -- Setting Options -- The Bottom Line -- Chapter 23: Working with Widely Used Objects in Excel -- Working with Charts -- Working with Windows -- Working with Find and Replace -- Adding Shapes -- The Bottom Line -- Chapter 24: Understanding the PowerPoint Object Model and Key Objects -- Getting an Overview of the PowerPoint Object Model -- Understanding PowerPoint's Creatable Objects -- Working with Presentations -- Working with Windows and Views -- Working with Slides -- Working with Masters -- The Bottom Line -- Chapter 25: Working with Shapes and Running Slide Shows -- Working with Shapes -- Working with Headers and Footers -- Setting Up and Running a Slide Show -- The Bottom Line -- Chapter 26: Understanding the Outlook Object Model and Key Objects -- Getting an Overview of the Outlook Object Model -- Working with the Application Object -- Understanding General Methods for Working with Outlook Objects -- Working with Messages -- Working with Calendar Items -- Working with Tasks and Task Requests -- Searching for Items -- The Bottom Line -- Chapter 27: Working with Events in Outlook -- Working with Application-Level Events.

Working with Item-Level Events -- The Bottom Line -- Chapter 28: Understanding the Access Object Model and Key Objects -- Getting Started with VBA in Access -- Getting an Overview of the Access Object Model -- Understanding Creatable Objects in Access -- Opening and Closing Databases -- Working with the Screen Object -- Using the DoCmd Object to Run Access Commands -- The Bottom Line -- Chapter 29: Manipulating the Data in an Access Database via VBA -- Understanding How to Proceed -- Preparing to Access the Data in the Database -- Opening a Recordset -- Accessing a Particular Record in a Recordset -- Searching for a Record -- Returning the Fields in a Record -- Editing a Record -- Inserting andDeleting Records -- Closing a Recordset -- The Bottom Line -- Chapter 30: Accessing One Application from Another Application -- Understanding the Tools for Communicating with Other Applications -- Using Automation to Transfer Information -- Using the Shell Function to Run an Application -- Using Data Objects to Store and Retrieve Information -- Communicating via DDE -- Communicating via SendKeys -- The Bottom Line -- Chapter 31: Programming the Office 2007 Ribbon -- Hiding the Editing Group on the Word Ribbon -- Working with Excel and PowerPoint -- Undoing Ribbon Modifications -- Selecting the Scope of Your Ribbon Customization -- Adding a New Group -- Adding Callbacks -- Adding Attributes -- Using Menus and Lists -- Toggling with a Toggle Button Control -- Modifying the Ribbon in Access -- Adding a Callback in Access -- What to Look For if Things Go Wrong -- Where to Go from Here -- The Bottom Line -- Appendix: The BottomLine Solutions -- Chapter 1: Recording and Running Macros in the Microsoft Office Applications -- Chapter 2: Getting Started with the Visual Basic Editor -- Chapter 3: Editing Recorded Macros.

Chapter 4: Creating Code fromScratch in the Visual Basic Editor.