WordTips: The Macros
fourth edition

WordTips: The Macros includes over 420 valuable macro-oriented tips. The following is the Table of Contents:

Introduction

• A Note about Word Versions
• Want to Learn More About Macros?
• Want to Learn About VBA Programming in Excel?
• How to Use the Macros in This Book
• Need More Tips?
• Sharing this Document

Creating and Managing Macros

• 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
• Unchanging Toolbars
• Changing Toolbar Buttons
• Locking the Position of Custom Toolbars
• Adding Your Own Menu Items
• Intelligible Names for Macros
• Assigning a Macro to a Shortcut Key
• 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 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
• 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 Parentheses
• Removing Tabs Used to Indent a Paragraph
• Determining if a Text Selection Has Been Made
• Including Headers and Footers when Selecting All
• Calculated Dates
• Converting Lists to Text
• Automatically Formatting an ASCII File
• Reversing a String
• Consistent Spacing
• Specific Capitalization
• Converting Text to Uppercase in a Macro
• Changing Text Case
• Intelligent Title Case
• Make AutoCorrect Pay Attention to Character Case
• Accessing Paragraphs in a Macro
• How to Paste Non-Floating Pictures with a Macro
• Pasting Clean Text
• Copying and Pasting Field Codes
• 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
• Reference to a Range of Endnotes
• Pulling Headers and Footers from Other Files
• Deleting All Headers and Footers
• Dynamic Path and Filename in a Footer
• Missing Header and Footer Toolbar
• Removing All Text Boxes In a Document
• 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
• Moving the Insertion Point to the Beginning of a Line
• Moving the Insertion Point to the End of a Line
• 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
• Searching for Floating Graphics
• Removing Pictures from Multiple Files
• Finding Text Boxes
• Searching for Non-Black Text
• 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
• Adjusting Small Caps Text
• Controlling the Hidden Text Attribute
• Resetting Paragraph Formatting
• Overlining Characters
• X-ing Out Text
• 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

Working With Styles and Templates

• Determining How Many Styles are Available
• Determining a Paragraph’s Style
• Finding In-Use Styles in a Macro
• Finding Unused Styles
• Removing Unused Styles
• Printing a List of Custom Styles
• Variant Style Names Appearing
• Preventing Styles from Changing
• Macro-Inserted AutoText Doesn't Set Style
• Batch Template Changes
• Continually Saving Normal.dot
• Disappearing Macro Menus
• Templates and Page Setup
• Editing AutoText Entries Directly

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
• Expanding Width of All Tables
• Moving Through a Table in a Macro
• Noting Table Rows Containing a Character
• Index Number for the Active Table
• Setting a Default Table Border Width
• Converting Tables to Text
• Formatting an ASCII Table with Spaces
• Formatting an ASCII Table with Tabs
• Differing Column Widths when Pasting
• Setting Consistent Shading
• Shading Rows in a Table
• Table Borders not Stored in AutoText
• Updating an Entire TOC from a Macro

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
• Enforcing a Do-Not-Use Word List
• Updating the Spelling Exclusion List Automatically
• Only Showing Readability Statistics
• Display Your Own Readability Statistics
• Underlining Section References Automatically
• Auto Creation of an Acronym List
• Tracked Changes Notification when Opening
• Turning Track Changes Off for Selected Areas
• Setting Change Bars Manually

Getting User Input

• Using Message Boxes
• Getting User Input in a Dialog Box
• Offering Options in a Macro

Working With Files and Directories

• Picking Up in the Last Document Edited
• 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
• 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
• Saving in Document Format from a Macro
• Automatically Saving Document Copies on A:
• Specifying a Backup Location
• Controlling Names of Backup Files
• Combining Documents
• An Automatic File Name
• 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
• 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

Interacting With the Word Environment

• Word's Object Model
• Finding and Changing Word's Internal Commands
• Grabbing the MRU List
• Saving Everything
• Opening Documents in Print Layout View
• The Case of the Vanished Menu Bar
• 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
• 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
• 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
• Determining the Number of Bookmarks Defined in a Document
• Getting the Names of Defined Bookmarks
• Selecting a Bookmark in a Macro
• Stubborn Foreign Languages
• Returning Word to Default Settings

Working With the Outside World

• Accessing a List of Outlook Contacts
• Setting Maximum Line Lengths in Word E-mail Messages
• Automatically Updating Fields and Links
• Avoiding the Update Links Message
• 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
• 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
• Printing Graphic Thumbnails
• Printing a Font List
• Printing a File List
• Printing the Active Document from a Macro
• Printing AutoCorrect Entries
• Printing Copy Numbers
• Printing Copy Numbers, Take Two
• Remembering Copies to Print
• Printing a Bookmark List
• 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
• Supplemental Word 2000 Macros
• Expanding Colors Available for Highlighting
• Embedding TrueType Fonts by Default

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
• 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
• Getting Rid of Many Hyperlinks
• Full Path Names in Word
• Inserting a File Name without an Extension
• That Stupid Word 97 Style List
• Selecting Sentences
• Bumping Numbers in a Document
• Using Sequential Document Serial Numbers
• Automatically Inserting Tomorrow’s Date
• Automatically Determining a Due Date
• Automatic Non-breaking Spaces in Dates
• Generating a List of Dates
• Auto-incrementing Form Fields
• Centering a Text Box
• Including Text Box Text In Word Counts
• Zooming With the Keyboard
• Moving Right by Sentences
• Moving Found Text Down On a Page
• Pulling Out Spelling Errors
• Finding Long Lines
• Mass Search and Replace
• Protecting Fields
• Updating Fields in Locked Forms
• Updating Calculated Fields in a Form
• Copying Form Field Contents
• Using Mandatory Form Fields
• Safely Relocking Forms
• 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
• Changing How Go To Works
• Repeating Actions
• Problems Using Words as Bullets
• Scaling Graphics in a Macro
• Determining Picture Size
• Extracting INCLUDEPICTURE File Names
• Odd Sorting
• Word Count for a Section
• Counting Characters in Text Boxes

Description	CD		Download
WordTips: The Macros (PDF version)			$29.77		(2.9 MB)
WordTips: The Macros (Word version)			$29.77		(2.4 MB)
WordTips: The Macros (Both PDF and Word versions)	$36.77

You can also order WordTips: The Macros by calling our order line: 801-607-2035.