Word VBA Guidebook (Table of Contents)

Word VBA Guidebook includes 247 information-packed pages. The following is the Table of Contents:

Introduction

• Who this Book is For
• What this Book Covers
• What is Not Covered
• Where to Go Next
• A Word about WordTips

1: Introducing Macros in Word

• Understanding VBA
• Introducing the Visual Basic Editor
• Displaying the Developer Tab
• How to Enable Macros
• Creating Macros
• Recording a Macro
• Writing a Macro from Scratch
• Running Macros
• Editing Macros
• Deleting Macros

2: Elements of Macros

• Projects and Modules
• Understanding Procedures
• Subroutines
• Functions
• Procedure Scope
• Adding Comments
• Continuing Lines
• Variables and Operators
• Understanding Data Types
• The Date Data Type
• The Object Data Type
• The Variant Data Type
• Understanding Operators
• Arithmetic Operators
• Comparison Operators
• Logical Operators
• String Operators
• Using Objects and Collections
• Word's Object Model
• Grouping Similar Objects Together
• Assigning Objects to Variables
• Understanding Object Members
• Doing Operations with Methods
• Working with Properties
• Making Sense of Members
• VBA Constants
• Using Literal Constants
• Creating Symbolic Constants
• Word's Enumerations

3: What's In a Name?

• Naming Macros
• Renaming Macros
• Where Macros are Stored
• Specifying a Location when Recording a Macro
• Specifying a Location when Creating a Macro from Scratch
• Event Handlers
• Automatic Macros
• Changing Built-In Word Commands

4: Understanding the VBA Environment

• Displaying the Visual Basic Editor
• Parts of the Environment
• The Menu Bar
• The Toolbar
• The Project Explorer
• The Properties Window
• The Code Window
• The Immediate Window
• Getting Help
• Searching for Help
• Navigating the Help System
• Customizing How VBA Works
• Program Options
• Project Properties
• Quitting the Visual Basic Editor

5: Managing Macros

• Adding Macros to Word's Interface
• Adding Macros to the Quick Access Toolbar
• Adding Macros to Ribbon Tabs
• Creating Shortcut Keys for Macros
• Using the Organizer
• Exporting Macros
• Importing Macros

6: Using Built-In Functions

• The Benefits of Functions
• Date and Time Functions
• How VBA Stores Times and Dates
• Determining Today's Date
• Determining the Current Time
• Getting Both the Time and Date
• Extracting Part of the Date
• Displaying a Weekday Name
• Extracting Part of the Time
• Differences between Two Dates
• Deriving a Date
• String Functions
• Comparing Strings
• Converting Strings
• Converting the Case of a String
• Converting Characters to Values
• Converting Values to Characters
• Converting a String to a Number
• Converting a Number to a String
• Creating Strings
• Other String Functions
• Finding the Length of a String
• Strings within Strings
• Extracting the Ends and Middle of a String
• Math Functions
• Extracting an Integer
• Generating Random Numbers
• Determining the Sign of a Number
• Positive Values
• Formatting

7: Controlling Program Flow

• Conditional Execution
• If ... Then
• Formatting If ... Then Structures
• Using Not With If...Then
• Select Case
• Switch
• Looping Structures
• For Loop
• Incrementing the Loop Counter
• Nesting a For Loop
• For Each Loop
• Do Loop
• The First Time Through
• Exiting a Loop
• While Loops
• GoTo

8: Using Data Structures

• Understanding Arrays
• Setting Up an Array
• Changing Arrays on the Fly
• Multidimensional Arrays
• Getting Information about an Array
• Starting to Count
• User-Defined Data Types

9: Dialog Boxes

• Creating a Message Box
• The Message
• The Title
• Icons, Buttons, and Responses
• Changing Icons
• Changing Buttons
• Combining Buttons and Icons
• User Feedback
• Getting User Input
• The Prompt
• The Title
• Default Input
• Screen Coordinates
• Built-In Dialog Boxes
• Available Dialog Boxes
• Displaying Dialog Boxes
• Accessing Dialog Box Settings

10: Working with a Document

• The Document Object
• Creating New Documents
• Opening Existing Documents
• Getting to a Document's Name
• Accessing Paragraphs
• Adding Paragraphs
• Accessing Paragraphs
• Deleting Paragraphs
• Accessing Styles
• Using Explicit Formatting
• Formatting Paragraphs
• Formatting Characters
• Using Bookmarks
• Adding Bookmarks
• Accessing Existing Bookmarks
• Deleting Bookmarks
• Saving Documents
• The Close Method
• The Save Method
• The SaveAs Method

11: Working with Selections and Ranges

• Creating a Selection
• Finding Information about the Selection
• General Information
• Selection Information
• Table Information
• Editing the Selection
• Adding Text
• Inserting Paragraphs
• Deleting Text
• Collapsing the Selection
• Creating a Range
• Editing a Range
• Adding Text
• Replacing Text
• Deleting Text

12: Working with Tables

• Creating Tables
• Changing Table Structure
• Deleting Rows and Columns
• Adding Rows and Columns
• Merging and Splitting Cells
• Changing Table Characteristics
• Changing Row Height and Column Width
• Changing Formatting
• Adding Information to Tables
• Deleting Tables

13: Searching and Replacing

• Finding Things
• Find Properties
• Executing a Search
• Using Find to Modify Your Document
• Replacing Things

14: Non-Document File Handling

• File Types
• Text Files
• Foreign File Formats
• Import/Export Formats
• File Basics
• Opening a File
• Handling File Errors
• Reading Data Files
• Closing Files
• Types of File Access
• Sequential Files
• Reading ASCII Text Files
• Writing to ASCII Text Files
• Reading Delimited Text Files
• Writing Delimited Text Files
• Random-Access Files
• Record Variables: User-Defined Types
• Opening Random-Access Files
• Reading Records from Random-access Files
• Writing Records to Random-Access Files
• Binary Files
• Opening Files for Binary Access
• Reading from Binary Access Files
• Writing to Binary-Access Files
• Updating the Current Position in a Binary File
• Determining the Current Position in a Binary File

15: Debugging and Error Handling

• What Are Bugs?
• Syntax-Related Errors
• Logic-Related Errors
• Operation-Related Errors
• Why are Bugs a Problem?
• Keeping Bugs Out
• What is Debugging?
• Getting Rid of Bugs
• Single Stepping
• What's Its Value?
• Stepping By Procedures
• Breakpoints
• Setting a Breakpoint
• Debugging Using Breakpoints
• Watch Expressions
• Breaking on Watches
• Editing a Watch

Description	CD	Download	Printed Book
Word VBA Guidebook	ISBN 978-1-61359-032-4 (247 pages) $29.99	ISBN 978-1-61359-031-7 (2 MB) $24.99	ISBN 978-1-61359-030-0 (247 pages) $29.99
Word Macros Power Pack   Great deal! You get both Word VBA Guidebook and WordTips: The Macros at a special bundled price.	ISBN 978-1-61359-085-0 (834 pages) $69.98 $49.98	ISBN 978-1-61359-084-3 (10 MB) $59.98 $42.98

Important: Because of outrageous shipping costs, I cannot ship the printed book outside the United States. The book is also available through Amazon, however.

You can also order Word VBA Guidebook by calling our order line: 801-607-2035.