WordTips: The Macros (Table of Contents)

Summary: Word includes a powerful macro programming language called Visual Basic for Applications. WordTips: The Macros can help you discover the power and capabilities of this language, and in the process extend Word in ways you never thought possible. Here is the complete table of contents for this book.

WordTips: The Macros (Table of Contents)

WordTips: The Macros, Eighth Edition, includes 717 information-packed pages. The following is the Table of Contents:

Introduction

  • How to Use the Macros in this Book
  • An Important Note about Word Versions
  • Want to Learn More about Macros?
  • Want to Learn about Excel Macros?
  • Get More Tips
  • A Special Note of Thanks
  • Sharing this Document

Creating and Managing Macros

  • Displaying the Developer Tab
  • Writing a Macro from Scratch
  • Continuing Macro Lines
  • Turning Off Screen Updating
  • Debugging a Macro
  • Renaming a Macro
  • Changing a Macro Description
  • Deleting a Macro
  • Understanding the Organizer
  • Using the Organizer to Manage Macros
  • Clean Up Your Macro List
  • Hiding Macros
  • Invisible Macros
  • Making Macros Readily Available
  • Making Macros Run Faster
  • Making Macros Run Faster, Take Two
  • Adding a Macro to a Toolbar
  • Adding a Macro to the Quick Access Toolbar
  • Unchanging Toolbars
  • Changing Toolbar Buttons
  • Changing ToolTips for a Macro Button
  • Locking the Position of Custom Toolbars
  • Macros On the Quick Access Toolbar
  • Adding Your Own Menu Items
  • Intelligible Names for Macros
  • Defining a Shortcut for a Macro
  • Removing a Macro from a Shortcut Key
  • Assigning a Macro to a Button in Your Text
  • Repeating In a Macro
  • Editing Word's Built-in Commands
  • Creating a Command List
  • Running Macros from Macros
  • Using Call to Run VBA Macros
  • Disabled Macros
  • Macro Error when Closing Document
  • Passwords for Creating Macros
  • Can't Save a Macro
  • Attaching Macros to Documents

Functions and Subroutines

  • Understanding Subroutines
  • Understanding Functions
  • Passing Parameters to Functions

Structures Used in Macros

  • Understanding the If ... End If Structure
  • Understanding the For ... Next Structure
  • Exiting a For ... Next Loop Early
  • Understanding the While...Wend Structure
  • Understanding the Select Case Structure

Working with Variables

  • Understanding Variables
  • Declaring Variables
  • Understanding Precedence
  • Setting a Variable from a Bookmark
  • Swapping Two Numbers
  • Swapping Two Strings
  • Comparing Strings
  • Dissecting a String
  • Converting Strings to Numbers
  • Converting Numbers to Strings
  • Determining the Upper Bounds of an Array
  • Quickly Clearing Array Contents
  • Understanding Document Variables

Commands and Statements

  • Creating a String
  • Determining the Length of a String
  • Trimming Spaces from Strings
  • Determining an Integer Value
  • Determining a Random Value
  • Determining an ANSI Value
  • Deriving an Absolute Value
  • Calculating a Future Date
  • Determining Differences between Dates
  • Determining the Month of the Year
  • Determining the Week of the Year
  • Determining the Day of the Year
  • Determining the Day of the Month
  • Determining the Hour of the Day
  • Determining If a File Exists
  • Determining the Size of a File
  • Converting Inches to Points
  • Repaginating in a Macro
  • Controlling Repagination in Macros
  • Checking for a Text Selection Length

Changing Information In a Document

  • Creating a New Document
  • Inserting Text with a Macro
  • Replacing Text in a Macro
  • Plain Text Pasting as the Default
  • Inserting a Paragraph from within a Macro
  • Inserting a Break with a Macro
  • Automatic Blank Pages at the End of a Section
  • Selecting an Entire Section
  • Cleaning Up Text in a Macro
  • Removing Extra Paragraph Marks
  • Adding Hyphens to Phrases
  • Finding Long Sentences
  • Dealing with Run-On Sentences
  • Deleting a Page
  • Automatically Inserting Brackets
  • Transposing Two Paragraphs
  • Transposing Two Words
  • Transposing Two Characters
  • Transposing Letters
  • Adding Quotes
  • Adding Smart Quotes through Macro Text
  • Smart Quote after Em Dash Faces Wrong Direction
  • Checking for Missing Quotation Marks
  • Adding Parentheses
  • Adding Serial Commas in a Sentence
  • Replacing the Last Comma
  • Removing Tabs Used to Indent a Paragraph
  • Deleting All Tab Stops
  • Replacing Random Text with Your Own Text
  • Determining if a Text Selection Exists
  • Calculated Dates
  • Monday's Date on Friday's Report
  • Adding Automatic Time Stamps
  • Converting Lists to Text
  • Converting Automatic Numbering to Manual Numbering
  • Automatically Formatting an ASCII File
  • Reversing a String
  • Occurrences of a Text String within a Document
  • Counting the Instances of a Text String
  • Consistent Spacing
  • Specific Capitalization
  • Capitalizing the First Letter after a Colon
  • Capitalizing the Word "I"
  • Converting Text to Uppercase in a Macro
  • Changing Text Case Many Times
  • Making Managerial Titles Lowercase
  • Intelligent Title Case
  • Make AutoCorrect Pay Attention to Character Case
  • Accessing Paragraphs in a Macro
  • Pasting Clean Text
  • Copying and Pasting Field Codes
  • Deleting All Fields
  • Shortcut to Display Bookmarks
  • Removing All Bookmarks
  • Random OLE Bookmarks
  • Deleting All Comments
  • Deleting All Footnotes
  • Automatically Adding Tabs in Footnotes
  • Sequentially Numbering Footnotes
  • Moving Footnote Text into the Document
  • Returning to Your Document after Adding an Endnote
  • Reference to a Range of Endnotes
  • Copying Custom Properties
  • Removing All File Properties
  • Converting Paragraphs to Comments
  • Changing Information in Multiple Documents
  • Processing Information Pasted from a PDF File
  • Automatic Sound Clips

Changing Location and Finding Information

  • Moving the Insertion Point in a Macro
  • Moving the Insertion Point to the Beginning of a Line
  • Moving the Insertion Point to the End of a Line
  • Jumping to the End of a Word
  • Detecting the Beginning of a Sentence in a Macro
  • Determining the Horizontal Position of the Insertion Point
  • Jumping to the Start or End of a Document
  • Moving to the Start or End of the Real Document
  • Jumping to the Top of a Page
  • Jumping to the End without Repaginating
  • Quickly Changing Document Windows
  • Positioning the Cursor in a New Document
  • Searching for Adjectives and Adverbs
  • Checking for Words and Phrases
  • Setting a Default for the Object Browser
  • Searching for Borders
  • Finding Text Not Using a Particular Font
  • Searching for Non-Black Text
  • Finding Quoted Text in VBA
  • Locating Locked Fields
  • Finding Changes, by Editor
  • Select All Changes by a Particular Reviewer

Changing Document Formatting

  • Setting the Left Indent of a Paragraph in a Macro
  • Setting the Right Indent of a Paragraph in a Macro
  • Double Indenting
  • Quickly Adjusting Paragraph Spacing
  • Aligning Paragraphs in a Macro
  • Getting Rid of Choppiness in Justified Text
  • Reversing Type
  • Using a Macro to Change the Formatting of All Instances of a Word
  • Selective Formatting in Replacements
  • Automatically Formatting Text within Quotes
  • Replacing Quoted Text with Italics
  • Underlining Quoted Text
  • Adjusting Space Before
  • Determining the Number of Fonts Available
  • Creating a Document Font List
  • Toggling Font Assignments in a Macro
  • Controlling the Italic Text Attribute
  • Controlling the Bold Text Attribute
  • Applying Bold Italics
  • Reversed Bolding
  • Changing Character Color
  • Discovering the RGB Value of a Custom Text Color
  • Adjusting Small Caps Text
  • Controlling the Hidden Text Attribute
  • Resetting Paragraph Formatting
  • Removing Shading from Many Paragraphs
  • Getting Rid of Manual Paragraph Numbering
  • Overlining Characters
  • X-ing Out Text
  • Highlighting Every Thousandth Character
  • Changing the Format of Existing Dates
  • Quickly Formatting Footers in Documents with Many Sections
  • Turning Off Default First Page Numbering
  • Formatting Footnote and Endnote References
  • Making Bookmarks Bold
  • Formatting Fractions
  • Single-Character Fractions
  • Controlling the Format of Cross-References
  • Resetting Character Formatting in a Macro
  • Finding Formatted Bulleted Paragraphs
  • Quickly Formatting Multiple Documents
  • Formatting Text Files
  • Rotating a Page of Text
  • Using the Format Painter with Editing Restrictions in Place

Working with Styles and Templates

  • Determining a Paragraph's Style
  • Determining How Many Styles are Available
  • Finding In-Use Styles in a Macro
  • Finding Unused Styles
  • Removing Unused Styles
  • Printing a List of Custom Styles
  • Variant Style Names Appearing
  • Saving Styles in a Macro
  • Preventing Styles from Changing
  • Making Sure Styles Don't Update Automatically
  • Ensuring that Spell Checking is Enabled in All Styles
  • Macro-Inserted AutoText Doesn't Set Style
  • Create a Template that Stops Styles from Being Added to a Document
  • Listing the Settings in a Template
  • Examining Styles and Macros in a Template
  • Batch Template Changes
  • Continually Saving Normal.dot
  • Templates and Page Setup
  • Updating Many Template References
  • Disappearing Macro Menus
  • Editing AutoText Entries Directly

Working with Headers and Footers

  • Including Headers and Footers when Selecting All
  • Pulling Headers and Footers from Other Files
  • Applying Standard Headers and Footers to a Document
  • Deleting All Headers and Footers
  • Inserting a Document's Path
  • Using a Portion of a Document's Filename in a Header
  • Dynamic Path and Filename in a Footer
  • Missing Header and Footer Toolbar
  • Moving Headings to the Next Page
  • Changing Roman Numerals to Arabic
  • Word Count for Headers and Footers
  • Changing the Link to Previous Default for Headers and Footers

Working with Tables

  • Filling Table Cells with a Macro
  • Putting Something in Every Cell of a Table
  • Setting Table Values to Three Decimal Places
  • Setting Decimal Tabs in a Table Using the Keyboard
  • Finding a Cell Reference
  • Fitting Text Into Cells
  • Adjusting Column Width from the Keyboard
  • Setting Consistent Column Widths in Multiple Tables
  • Stopping Row Breaking for Many Tables
  • Expanding Width of All Tables
  • Moving Through a Table in a Macro
  • Jumping to a Table Row
  • Tabbing from One Table to the Next
  • Noting Table Rows Containing a Character
  • Placing Text in Empty Table Cells
  • Index Number for the Active Table
  • Setting a Default Table Border Width
  • Copying Fill Color in a Table
  • Getting Rid of Background Color in All Tables
  • Copying All Tables to a New Document
  • Converting Tables to Text
  • Formatting an ASCII Table with Spaces
  • Formatting an ASCII Table with Tabs
  • Differing Column Widths when Pasting
  • Applying Consistent Shading to a Table
  • Shading Table Rows
  • Finding and Deleting Rows
  • Table Borders not Stored in AutoText
  • Nudging a Table
  • Updating an Entire TOC from a Macro
  • Hyperlinks from Headings to the TOC
  • Jumping Back to the TOC

Working with Graphics and Text Boxes

  • How to Paste Non-Floating Pictures with a Macro
  • Searching for Floating Graphics
  • Default Picture Settings
  • Anchoring Objects by Default
  • Scaling Graphics in a Macro
  • Determining Picture Size
  • Counting All Graphics
  • Rotate a Graphic Using the Keyboard
  • Inserting an Image On a Specific Page
  • Inserting Multiple Graphics in a Document
  • Removing Pictures from Multiple Files
  • Extracting INCLUDEPICTURE File Names
  • Printing Images Based on Hidden Text Setting
  • Finding Text Boxes
  • Finding an Invisible Text Box
  • Centering a Text Box
  • Updating a Field in a Text Box
  • Characters in the Margin Next to Paragraphs
  • Removing All Text Boxes In a Document
  • Counting Characters in Text Boxes
  • Including Text Box Text In Word Counts

Working with Word's Tools

  • Opening the Document Map by Default
  • Importing AutoCorrect Entries
  • Managing the AutoCorrect List
  • Toggling AutoCorrect Settings
  • Spell Checking Forms
  • Limiting a Spelling Check
  • Spell Checking when Closing Documents
  • Enforcing a Do-Not-Use Word List
  • Updating the Spelling Exclusion List Automatically
  • Avoiding the "Check Remainder" Dialog Box
  • Only Showing Readability Statistics
  • Display Your Own Readability Statistics
  • Underlining Section References Automatically
  • Auto Creation of an Acronym List
  • Creating Multiple Highlighter Tools
  • Tracked Changes Notification when Opening
  • Turning Track Changes Off for Selected Areas
  • Examining Tracked Changes in a Macro
  • Removing the Time Stamp from Tracked Changes
  • Setting Default Options for Track Changes
  • Setting Change Bars Manually
  • Sorting Comments by Date
  • Changing the User Name in Existing Comments
  • Deleting Commented Text
  • Inserting Initials and Date in a Comment
  • Counting Changed Words
  • Word Counts for a Group of Documents
  • Changing Pronoun Gender
  • Adding Quoted Words to an Index
  • Putting Bold Words in an Index

Getting User Input

  • Using Message Boxes
  • Getting User Input in a Dialog Box
  • Changing What Is Pasted in a Dialog Box
  • Offering Options in a Macro

Working with Files and Directories

  • Picking Up in the Last Document Edited
  • Displaying the Document Title Right Away
  • Getting Input from a Text File
  • Saving Information in a Non-Document Text File
  • Determining If the End of a Text File Has Been Reached
  • Determining the Length of a Non-Document Text File
  • Appending to a Non-Document Text File
  • Renaming a File
  • Using a Standard Format in a Suggested File Name
  • Setting a Document Naming Convention
  • Opening a Text File and Template from the Command Line
  • Using Seek In a Macro
  • Saving a Document in a Macro
  • Saving in a Macro Using a Desired File Name
  • Passing a Data File Name via Command Line to a Macro
  • Saving in Document Format from a Macro
  • Mirroring Documents
  • Automatically Saving Document Copies on A:
  • Specifying a Backup Location
  • Controlling Names of Backup Files
  • Combining Documents
  • An Automatic File Name
  • Creating Multiple Blank Documents in One Step
  • Changing the Default Drive
  • Creating a Directory
  • Changing Directories in a Macro
  • Determining the Current Directory
  • Removing a Directory
  • Locating the My Documents Folder
  • Creating Files with Mail Merge
  • Merging to Individual Files
  • Saving Personalized Copies of a Document
  • Importing a Text File and Inserting after a Bookmark
  • Copying a File
  • Deleting the Open Document File
  • Marking Multiple Documents
  • Saving Documents as Read-Only by Default
  • Modifying Behavior of the Open Dialog Box
  • Breaking Links in Lots of Documents
  • Converting Files to Word 2007 Format

Interacting with the Word Environment

  • Word's Object Model
  • Finding and Changing Word's Internal Commands
  • Grabbing the MRU List
  • Minimizing the Ribbon for a Document
  • Displaying Properties Dialog Box in a Macro
  • Saving Everything
  • Opening Documents in Print Layout View
  • The Case of the Vanished Menu Bar
  • Minimizing the Ribbon for a Document
  • Viewing Side-by-Side Pages
  • Clearing the Undo Stack in a Macro
  • Changing the Maximum Undo Levels
  • Button for Leaving Full-Screen Mode
  • Persistent Reviewing Toolbar Display
  • Suppressing the Control Toolbox Toolbar
  • Changing Stubborn Ruler Measurements
  • Stopping Smart Tags from Being Saved
  • Displaying the Outlining Toolbar by Default
  • Hiding the Reviewing Toolbar
  • Displaying the File Tab of the Ribbon by Default
  • Displaying the Navigation Pane when Opening a Document
  • Automatically Opening a Document at a Specific Zoom Setting
  • Determining the Number of Paragraphs in a Document
  • Determining the Number of Pages in Your Document
  • Determining the Current Page Number
  • Limiting Directories in the FILENAME Field
  • Restoring a Keyboard Shortcut
  • Displaying a Message in the Status Bar
  • Displaying the User Name in the Status Bar or Title Bar
  • Determining if Num Lock is On
  • Determining if Caps Lock is On
  • Determining if Overtype Mode is Active
  • Determining How Many Windows are Open
  • Counting Open Document Windows
  • Default Units that Change
  • Turning on Large Icons in a Macro
  • Problem With Add-on Macros
  • Changing the View in File New
  • Preventing the Loss of Personal Information
  • Determining the Number of Bookmarks Defined in a Document
  • Getting the Names of Defined Bookmarks
  • Getting Bookmark Information
  • Selecting a Bookmark in a Macro
  • Stubborn Foreign Languages
  • Returning Word to Default Settings
  • Detecting an Open Dialog Box
  • Clicking to Scroll Down Freezes
  • Accessing the Dirty Flag

Working with the Outside World

  • Accessing a List of Outlook Contacts
  • Setting Maximum Line Lengths in Word E-mail Messages
  • Counting Fields in a Document
  • Field in Footer Won't Update
  • Automatically Updating Fields and Links
  • Embedding Linked Documents
  • Avoiding the Update Links Message
  • Counting Internal Links
  • Unlinking an Excel Chart Automatically
  • Word Link to Create a New Excel Workbook

Working with the Printer

  • Including a Printer's Name in a Footer
  • Changing Print Dialog Box Defaults
  • Changing the Default "Print What" Setting
  • Easily Changing Print Order
  • Temporarily Changing the Printer in a Macro
  • Two Printed Copies to Different Paper Trays
  • Printing and Exiting Word in a Macro
  • Printing All Open Documents
  • Printing via Macro without Messages
  • Setting the Default Print Preview Zoom Factor
  • Printing Styles in a Macro
  • Printing On Both Sides of the Paper
  • Printing Comments
  • Printing Shortcut Key Assignments from a Macro
  • Printing Summary Information from a Macro
  • Printer Name on the Status Bar
  • Correct Line Numbers When Printing Selections
  • Automatic Page Numbers across Multiple Documents
  • Printing Graphic Thumbnails
  • Printing a Font List
  • Printing a File List
  • Printing a Macro List
  • Printing a Full Style Sheet
  • Printing the Active Document from a Macro
  • Printing AutoCorrect Entries
  • Printing a List of Building Blocks
  • Printing Copy Numbers
  • Remembering Copies to Print
  • Printing a Bookmark List
  • Printing a Bookmark List with Contents
  • Printing a List of AutoCorrect Entries
  • Printing without Footnotes
  • Printing Personalized Copies of a Document
  • Working With Multiple Printers
  • Specifying a Paper Tray in a Macro
  • Documents Printing Out of Order
  • Printing Color Separations
  • Printing Custom Properties
  • Suppressing ASK Fields When Printing
  • Default Envelope Margins

Special-Purpose Macros

  • Automatically Running a Macro
  • Bypassing the Startup Macro
  • Using AutoCorrect to Start Macros
  • Running Macros Based on Keywords
  • Supplemental Word 2000 Macros
  • Expanding Colors Available for Highlighting
  • Embedding TrueType Fonts by Default
  • Automating a Manual Process with a Macro

Macro Cookbook

  • Numbers Spelled Out
  • Numbers to Text, Take Two
  • Numbers to Text, Take Three – Over a Million
  • Counting Words the Old Fashioned Way
  • Determining Word Frequency
  • Generating a Count of Word Occurrences
  • Character Frequency Count
  • Running Word Counts
  • Displaying a Live Word Count
  • Highlight Words from a Word List
  • Determining If a Number is Odd or Even
  • Strip Trailing Spaces
  • Reverse Numbered Lists
  • Sharing Headings with Others
  • Selecting to the Next Punctuation Mark
  • Checking for Matching Parentheses
  • Breaking Lines in E-mail
  • Finding an Unknown Character
  • Talking to Yourself
  • A Real AutoSave
  • Saving Changes when Closing
  • Creating an AutoText Reference List
  • Screen Flip Flop
  • Making Live URLs Into Normal Text
  • Hyperlinks in Protected Documents
  • Removing HTTP from URLs
  • Changing from Absolute to Relative Hyperlinks
  • Getting Rid of Many Hyperlinks
  • Full Path Names in Word
  • Inserting a File Name without an Extension
  • Selecting Sentences
  • Bumping Numbers in a Document
  • Using Sequential Document Serial Numbers
  • Making Sure a Document Always Has an Even Number of Pages
  • Automatically Inserting Tomorrow's Date
  • Forcing the Date to the Next Wednesday
  • Automatically Determining a Due Date
  • Automatic Non-breaking Spaces in Dates
  • Generating a List of Dates
  • Auto-incrementing Form Fields
  • Zooming with the Keyboard
  • Moving Right by Sentences
  • Moving Found Text Down On a Page
  • Pulling Out Spelling Errors
  • Finding Long Lines
  • Protecting Fields
  • Updating Fields in Locked Forms
  • Updating Calculated Fields in a Form
  • Copying Form Field Contents
  • Using Mandatory Form Fields
  • Safely Relocking Forms
  • Handling Returns in Form Data
  • Automatically Setting Right Leader Tabs
  • Protecting Hidden Text
  • Quickly Switching Languages
  • Capitals After Colons
  • An Automatic Two Spaces After a Period
  • Tiling Documents
  • Checking for a Security Certificate
  • Counting Characters in a Selection
  • Repeating Actions
  • Problems Using Words as Bullets
  • Ignoring Smart Quotes when Comparing Text
  • Odd Sorting
  • Sorting by Highlighting
  • Word Count for a Section
  • Displaying a Column Number

Description CD Download
WordTips: The Macros Buy on CD
ISBN 978-1-61359-349-3 (717 pages)
$41.99
Buy Download
ISBN 978-1-61359-248-6 (8.9 MB)
$34.99

You can also order WordTips: The Macros by calling our order line: 307-200-0450.

Links and Sharing
  • Ask a Question
  • Make a Comment
  • Free Calendars
  • Share