book

Writing Word Macros, Second Edition

Name: Writing Word Macros, Second Edition
Author: Steven Roman PhD
ISBN: 9781565927254

by Steven Roman PhD

October 1999

Beginner

410 pages

10h 45m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Writing Word Macros, 2nd Edition
Preface
A Title Change and Word 2000 Compliance
The Book’s Audience
Organization of This Book
The Book’s Sample Code
Obtaining the Sample Programs
Conventions in This Book
How to Contact Us
Acknowledgments
1. Introduction
2. Preliminaries
What Is a Programming Language?

Programming Style
CommentsReadabilityModularity
I. The VBA Environment
3. The Visual Basic Editor, Part I
The Project WindowProject NamesProject ContentsDocument objectsStandard modulesClass modulesUserForm objectsReferences
The Properties Window
The Code Window
Procedure and Full-Module ViewsThe Object and Procedure List BoxesA Document objectA standard moduleA UserForm object
The Immediate Window
Arranging Windows
Docking
Document Events
4. The Visual Basic Editor, Part II
Navigating the IDEGeneral NavigationNavigating the Code Window at Design TimeTracing CodeBookmarks
Getting Help
Creating a Procedure
Run Mode, Design Mode, and Break Mode
Errors
Design-Time ErrorsCompile-Time ErrorsRun-Time ErrorsLogical Errors
Debugging
TracingStep Into (F8)Step Over (Shift-F8)Step Out (Ctrl-Shift-F8)Run To CursorChanging the next statement to executeBreaking out of debug modeWatching ExpressionsQuick Watch (Shift-F9)The Locals and Watch Window
Macros
Recording MacrosRunning Macros
II. The VBA Programming Language
5. Variables, Data Types, and Constants
Comments
Line Continuation
Constants
Enums
Variables and Data Types
Variable DeclarationThe Importance of Explicit Variable DeclarationOption ExplicitNumeric Data TypesBoolean Data TypeString Data TypeDate Data TypeVariant Data TypeWord Object Data TypesThe generic As Object declarationThe Set statementArraysThe dimension of an arrayDynamic arraysThe UBound functionVariable Naming ConventionsVariable ScopeProcedure-level (local) variablesModule-level variablesVariable LifetimeStatic variablesVariable Initialization
VBA Operators
6. Functions and Subroutines
Calling FunctionsIgnoring Return Values
Calling Subroutines
Parameters and Arguments
Optional ArgumentsNamed ArgumentsByRef Versus ByVal Parameters
Exiting a Procedure
Public and Private Procedures
Referencing a Project
Fully Qualified Procedure Names
7. Built-in Functions and Statements
The MsgBox Function
The InputBox Function
VBA String Functions
Miscellaneous Functions and Statements
8. Control Statements
The If… Then Statement
The For Loop
Exit For
The For Each Loop
The Do Loop
Infinite Loops
The Select Case Statement
A Final Note on VBA
File-Related FunctionsDate- and Time-Related FunctionsThe Format FunctionErrors!
III. Objects and Object Models
9. Object Models
Objects, Properties, and MethodsPropertiesMethodsReading the help files
Collection Objects
The Documents Collection: An Example of a CollectionThe Count propertyThe Add methodThe Item methodThe Base of a Collection
Object Model Hierarchies
Object Model Syntax
Object Variables
The With StatementObject Variables Save Execution TimeAn Object Variable Is a PointerFreeing an Object Variable: The Nothing KeywordThe Is OperatorDefault MembersNamed ArgumentsThe New KeywordGlobal Objects
10. The Word Object Model
The Word Object Model: A Perspective
Word Enums
The VBA Object Browser
11. The Application Object
Properties and MethodsThe ActiveDocument PropertyThe ActivePrinter PropertyThe Build and Version PropertiesThe ListCommands MethodThe OnTime MethodThe PrintPreview PropertyThe Quit MethodThe Selection PropertyThe FontNames Collection
The Options Object
The System Object
The Task Object
The Template Object
The AttachedTemplate PropertyProperties and Methods of the Template ObjectCreating a Template
The Window Object
Windows, Panes, and ViewsThe Windows CollectionCreating a New WindowThe Add methodThe NewWindow methodProperties and Methods of the Window ObjectArranging open windowsScrolling properties and methodsSpecial viewsAdditional properties and methods of the Window object
The Pane Object
Creating New PanesThe Add methodThe Split propertyThe SplitVertical propertyProperties and Methods of the Pane ObjectThe AutoScroll method
The View Object
The Type PropertyThe Show Properties
The Zoom Object
Properties of the Zoom Object
12. The Document Object
Properties That Return Collections
Spelling-Related Properties and Methods
The Documents Collection
Adding, Opening, and Saving Documents
Password-Related Properties
Protection-Related Properties and Methods
The Name Properties
Printing-Related Methods
Printing to a FileRestricted PrintingOther ParametersPrintPreview
Additional Members of the Document Object
Children of the Document Object
The Bookmark ObjectCreating a bookmarkThe Exists methodThe Copy methodThe Delete methodThe Empty propertyThe Start, End, and Range propertiesThe Name propertyThe Select methodThe StoryType propertyThe Characters, Words, and Sentences CollectionsThe Fields CollectionDetermining field textThe Code and Result propertiesThe Delete methodThe DoClick methodThe Index propertyThe Kind propertyThe Locked propertyThe Next and Previous propertiesThe ShowCodes propertyThe Type propertyThe Update methodList-Related ObjectsThe PageSetup ObjectThe Paragraph ObjectThe CloseUp methodThe Format propertyThe Indent methodThe Range propertyThe TabStops propertyThe ParagraphFormat ObjectTab StopsThe TabStops collectionThe TabStop objectThe Style ObjectCreating a new styleThe AutomaticallyUpdate propertyThe BaseStyle propertyThe BuiltIn propertyThe Description propertyThe InUse propertyThe Type propertyThe ParagraphFormat propertyThe Variable ObjectCreating a Variable object
Example: Printing Document Headings
Example: Finding Used Styles
13. The Section and HeaderFooter Objects
Adding a New Section
The PageSetup Object
Properties of the Section Object
The HeaderFooter Object
Different Odd and Even Headers or FootersProperties of the HeaderFooter ObjectThe Exists propertyThe IsHeader propertyThe LinkToPrevious propertyAdding page numbers to a header or footerExample: Setting Headers
14. The Range and Selection Objects
Comparing the Range and Selection Objects
Range and Selection Variables
Creating a Range or Selection Object
The Entire DocumentA Single PointThe Range Method and the Range PropertyThe FormattedText PropertyCharacters, Words, and SentencesThe GoTo MethodsThe ConvertToText MethodThe Find ObjectThe Field ObjectThe TextRange Property
Changing a Range Object
The Next and Previous MethodsThe SetRange MethodThe Start and End PropertiesThe StartOf and EndOf MethodsThe HomeKey and EndKey MethodsThe Collapse MethodThe Expand MethodThe Extend MethodThe Shrink MethodThe WholeStory MethodThe Move MethodsThe MoveUntil MethodsThe MoveWhile MethodsThe MoveUp, MoveDown, MoveLeft, and MoveRight MethodsMoveDown or MoveUpMoveLeft or MoveRight
Range and Selection Object Properties and Methods
The Text and TextRetrievalMode PropertiesEdit MethodsInsert MethodsThe InsertAfter and InsertBefore methodsThe InsertBreak methodThe InsertCaption methodThe InsertDateTime methodThe InsertFile methodThe InsertParagraph, InsertParagraphAfter, and InsertParagraphBefore methodsThe InsertSymbol methodCharacter and Paragraph Formatting PropertiesFont-related propertiesThe Borders and Shading propertiesThe Case propertyThe PageSetup propertyThe ParagraphFormat propertyThe Style propertyKeyboard simulationMiscellaneous Properties and MethodsInformation propertySelecting a rangeDeleting a range or selectionDuplicating a rangeThe IsEqual, InRange, and InStory methodsCollection propertiesThe ConvertToTable methodSorting text
15. The Find and Replace Objects
Searching for TextThe Wrap PropertyThe Found PropertyConsequences of a Successful Search
Searching for Formatting
The Replace Operation
The Execute Method
Example: Repeated Searching
16. The Table Object
Formatting-Related Properties and Methods
The Cell Method
The Columns and Rows Properties
The ConvertToText Method
Sorting Methods
The Split Method
Example: Creating Tables from Word Lists
Example: Closing Up a Table
17. The List Object
List TypesWhat Is a List?Bulleted ListsNumbered Lists
The List Object
The ListTemplate Object and ListGalleries
ListGallery ObjectsThe ListTemplate ObjectThe ListLevel ObjectThe ListTemplates CollectionsThe ListFormat ObjectThe Apply…Default methodsThe ApplyListTemplate methodThe ConvertNumbersToText methodThe CountNumberedItems methodThe List propertyThe ListIndent, ListOutdent, and ListLevelNumber methodsThe ListString and ListValue propertiesThe ListTemplate propertyThe ListType propertyThe RemoveNumbers methodThe SingleList propertyThe SingleListTemplate property
Example: Looking at Lists
18. Shortcut Key Bindings
Finding a Key Binding
Creating a Key Binding
The KeyBinding Object
Finding a Key BindingThe KeysBoundTo CollectionExample: Listing Key Bindings
19. Built-in Dialog Objects
The Show Method
The Display and Execute Methods
The DefaultTab Property
The Type Property
The Update Method
Example: Printing Document Statistics
20. Custom Dialog Boxes
What Is a UserForm Object?Creating a UserForm ObjectWindows ControlsAdding UserForm Code
Example: Adding a Closing to a Letter
Add a UserForm Object and Set Its PropertiesAdd Controls to the FormAdd Code to the FormActivating the Application
Example: A Fax Cover Sheet
Example: Quick Selection
21. Menus and Toolbars
An Overview
CustomizationContext
The CommandBars Collection
The CommandBar Object
Creating a New Menubar or Toolbar
Command Bar Controls
Creating a New Command Bar ControlBuilt-in Command Bar Control IDsExample: Creating a MenuExample: Creating a Toolbar
IV. Appendixes
A. Programming Word from Another Application
Setting a Reference to the Word Object Model
Getting a Reference to the Word Application Object
An Alternative Approach
The CreateObject FunctionThe GetObject FunctionNo Object Library Reference
B. The Shape Object
The Shape and InLineShape Objects
Z-Order
Creating InLineShapes
Creating Shapes
AutoShapesThe TextFrame ObjectThe FillFormat Object
Examples
WordArt
C. Getting the Installed Printers
D. High-Level and Low-Level Languages
BASIC
Visual Basic
C and C++
Visual C++
Pascal
FORTRAN
COBOL
Lisp
Index
Colophon

Content preview from Writing Word Macros, Second Edition

The Properties Window

The Properties window (see Figure 3-4) displays the properties of an object and allows us to change these properties.

When a standard module is selected in the Project window, the only property that appears in the Properties window is the module’s name. However, when a document is selected in the Projects window, many of the document’s properties appear in the Properties window, as shown in Figure 3-4.

The Properties window can be used to change some of the properties of the object while no code is running—that is, at design time. Note, however, that some properties are read-only and cannot be changed. Other properties can be changed only by code, that is, at run time. Such properties generally do not appear in the Properties window.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781565927254Catalog Page Errata

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Writing Word Macros, Second Edition

by Steven Roman PhD

The Properties Window

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

More than 5,000 organizations count on O’Reilly

Julian F.

Addison B.

Amir M.

Mark W.

You might also like

101 Ready-To-Use Excel Macros

Writing Excel Macros with VBA, 2nd Edition

Word 2013 Bible

VB & VBA in a Nutshell: The Language

Publisher Resources