This advanced Word VBA macro programming course is designed for users who are already comfortable with the basics of Word VBA macros, and who have progressed beyond relying on the Macro Recorder.
If you are still new to Word VBA, have a look at the Udemy course "Microsoft Word VBA Macro Programming – Introduction".
This advanced Word VBA course carries on from where the above Introductory course finishes.
The main purpose of this course is to take a deep dive into programming the Word VBA object model; but in a practical, hands-on kind of way.
Here’s a summary of what you will learn:
- You will learn how to program the Application object, which represents Word itself; how to check the user's location and screen resolution; and how to check which fonts are used in a particular document.
- Moving onto files and documents, you will learn how to process all files in a given Folder; how to archive files older than a certain date; and how to test whether a given Document is currently open.
- Next, when we turn our attention to the Range and Selection objects, you will learn the similarities and differences between these two objects; and when to use one in preference to the other. You'll learn the important Word programming skills of verifying the type of object which is currently selected and checking the page location of the selection.
- In the chapter on Word text objects, you will learn the VBA syntax for processing paragraphs, sentences, words, characters and ranges. You will gain confidence in how to have your macros perform operations like inserting text and copying text without wiping the user's clipboard. This is also the section in which you will learn how to program the Range.Find object to find and replace both text and formatting attributes; how to change the Case of Text, how to create bulleted and numbered lists; how to use the Word VBA objects used which control the formatting of text; how to create style; and how to create tables of contents.
- Once we’ve covered the nuts and bolts of working with text, we'll examine the code which you need when working with longer, more complex documents. In this section, you will learn how to create sections, headers and footers; how to work with odd and even headers and footers; how to use the LinkToPrevious Property; inserting Page Numbers; insert an image into a Header; and how to program the PageSetup Object.
- Then we'll turn our attention to creating and manipulating tables with VBA code; performing such operations as merging cells, formatting tables, converting text to a table, we'll create a macro which will transpose the rows and columns of the currently selected table.
- The course also covers content controls and interactive forms. You will learn how to combine this powerful feature with VBA programming; how to create content controls programmatically; and how to write code which responds to content control events.
- Towards the end of the course, we'll discuss the different ways of distributing Your VBA macro solutions.
- And, to end the course, we'll create a series of solutions which demonstrate how to write Word VBA code which controls not only the Word object model, but the object models of other Microsoft Office programs. We'll create three inter-application solutions: the first combining Word and Excel workflows; the second Word and Outlook; and the third, Word and PowerPoint.
So, by the end of this course, you will have a good grasp of all of the intermediate and advanced Word VBA programming techniques that you'll need to master, in order to feel comfortable when undertaking Word VBA projects; either in the workplace, or as a consultant.
- Welcome to Advanced Word VBA Programming
The Application object
The Document Object
- Processing all Files in a Folder
- Archiving Old Files
- The Documents Collection
- Testing Whether a Document is Open
- Creating, Opening and Closing Documents
The Range and Selection Objects
- The Range and Selection Objects compared
- Verifying the Selection Type
- Verifying the Selection Story
- Verifying Selection or Range Information
Working with Text
- Working with Paragraphs
- Working with Words and Characters
- Copying Text
- Inserting Text
- Using the Find Object
- Changing the Case of Text
- Working with Lists
- Formatting text
- Working with styles
- Creating a Table of Contents
Sections, Headers and Footers
- Creating Sections
- The PageSetup Object
- Creating Headers and Footers
- The LinkToPrevious Property
- Odd and Even Headers and Footers
- Inserting Page Numbers
- Inserting an Image into a Header
Working with Tables
- Creating Tables
- Merging cells
- Formatting Tables
- Converting Text to a Table
- Transposing a table
- Sorting Table Data
Content Controls and Interactive Forms
- Customizing Placeholder Text
- Creating Content Controls Programmatically
- Control Events
- Drop-down Lists and Combo Boxes
- Using the Picture Control
Distributing Your VBA Solutions
- Distributing raw VBA code
- Distributing a VBA module
- Distributing a Word Addin
Targeting Other Office Programs
- Referencing other Office Applications
- Controlling Excel from a Word Macro
- Controlling Outlook from a Word Macro
- Controlling PowerPoint from a Word Macro