Books & Videos

Table of Contents

  1. Chapter 1 Introduction

  2. Chapter 2 Preliminaries

    1. What Is a Programming Language?

    2. Programming Style

  3. The VBA Environment

    1. Chapter 3 The Visual Basic Editor, Part I

      1. The Project Window
      2. The Properties Window
      3. The Code Window
      4. The Immediate Window
      5. Arranging Windows
      6. Document Events
    2. Chapter 4 The Visual Basic Editor, Part II

      1. Navigating the IDE
      2. Getting Help
      3. Creating a Procedure
      4. Run Mode, Design Mode, and Break Mode
      5. Errors
      6. Debugging
      7. Macros
  4. The VBA Programming Language

    1. Chapter 5 Variables, Data Types, and Constants

      1. Comments
      2. Line Continuation
      3. Constants
      4. Variables and Data Types
      5. VBA Operators
    2. Chapter 6 Functions and Subroutines

      1. Calling Functions
      2. Calling Subroutines
      3. Parameters and Arguments
      4. Exiting a Procedure
      5. Public and Private Procedures
      6. Referencing a Project
    3. Chapter 7 Built-in Functions and Statements

      1. The MsgBox Function
      2. The InputBox Function
      3. VBA String Functions
      4. Miscellaneous Functions and Statements
    4. Chapter 8 Control Statements

      1. The If… Then Statement
      2. The For Loop
      3. The For Each Loop
      4. The Do Loop
      5. The Select Case Statement
      6. A Final Note on VBA
  5. Objects and Object Models

    1. Chapter 9 Object Models

      1. Objects, Properties, and Methods
      2. Collection Objects
      3. Object Model Hierarchies
      4. Object Model Syntax
      5. Object Variables
    2. Chapter 10 The Word Object Model

      1. The Word Object Model: A Perspective
      2. Word Enums
      3. The VBA Object Browser
    3. Chapter 11 The Application Object

      1. Properties and Methods
      2. The Options Object
      3. The Task Object
      4. The Template Object
      5. The Window Object
      6. The Pane Object
      7. The View Object
      8. The Zoom Object
    4. Chapter 12 The Document Object

      1. Properties That Return Collections
      2. Spelling-Related Properties and Methods
      3. The Documents Collection
      4. Adding, Opening, and Saving Documents
      5. Password-Related Properties
      6. Protection-Related Properties and Methods
      7. The Name Properties
      8. Printing-Related Methods
      9. Additional Members of the Document Object
      10. Children of the Document Object
      11. Example: Printing Document Headings
      12. Example: Finding Used Styles
    5. Chapter 13 The Section and HeaderFooter Objects

      1. Adding a New Section
      2. The PageSetup Object
      3. Properties of the Section Object
      4. The HeaderFooter Object
    6. Chapter 14 The Range and Selection Objects

      1. Comparing the Range and Selection Objects
      2. Range and Selection Variables
      3. Creating a Range or Selection Object
      4. Changing a Range Object
      5. Range and Selection Object Properties and Methods
    7. Chapter 15 The Find and Replace Objects

      1. Searching for Text
      2. Searching for Formatting
      3. The Replace Operation
      4. The Execute Method
      5. Example: Repeated Searching
    8. Chapter 16 The Table Object

      1. Formatting-Related Properties and Methods
      2. The Cell Method
      3. The Columns and Rows Properties
      4. The ConvertToText Method
      5. Sorting Methods
      6. The Split Method
      7. Example: Creating Tables from Word Lists
      8. Example: Closing Up a Table
    9. Chapter 17 The List Object

      1. List Types
      2. The List Object
      3. The ListTemplate Object and ListGalleries
      4. Example: Looking at Lists
    10. Chapter 18 Shortcut Key Bindings

      1. Finding a Key Binding
      2. Creating a Key Binding
      3. The KeyBinding Object
    11. Chapter 19 Built-in Dialog Objects

      1. The Show Method
      2. The Display and Execute Methods
      3. The DefaultTab Property
      4. The Type Property
      5. The Update Method
      6. Example: Printing Document Statistics
    12. Chapter 20 Custom Dialog Boxes

      1. What Is a UserForm Object?
      2. Example: Adding a Closing to a Letter
      3. Example: A Fax Cover Sheet
      4. Example: Quick Selection
    13. Chapter 21 Menus and Toolbars

      1. An Overview
      2. CustomizationContext
      3. The CommandBars Collection
      4. The CommandBar Object
      5. Command Bar Controls
  6. Appendixes

    1. Appendix Programming Word from Another Application

      1. Setting a Reference to the Word Object Model
      2. Getting a Reference to the Word Application Object
      3. An Alternative Approach
    2. Appendix The Shape Object

      1. The Shape and InLineShape Objects
      2. Z-Order
      3. Creating InLineShapes
      4. Creating Shapes
      5. Examples
      6. WordArt
    3. Appendix Getting the Installed Printers

    4. Appendix High-Level and Low-Level Languages

      1. BASIC
      2. Visual Basic
      3. C and C++
      4. Visual C++
      5. Pascal
      6. FORTRAN
      7. COBOL
      8. Lisp
  1. Colophon