Demystifying Macros and VBA: The Secrets of Automating Word

This 1-day in-depth course demystifies Word Macros and is designed to give you the tools for creating and understanding macros that can automate and speed up mundane, repetitive tasks.

Understanding the essentials of the Visual Basic code as used in Word macros can help you to set up efficient macros to do the work for you.

This course covers:

• What is a macro
• Types of Word macros
• Creating Word macros
• Getting to know the Word IDE
• Where the macros are kept
• Introduction to the Word object oriented DOM (document object model)
• Just enough VBA programming to get you started
• Making your macros accessible
• What to do if things go wrong: debugging
• And more…

Learn how to use and write Word macros so you can do things in Word that until now you could only dream of doing. Having a command of building macros can greatly enhance your efficiency in writing Word documents and also you can have fun while doing it!

The course includes hands-on practice and reviewing and analyzing a list of useful macro functions.

Topics include:

• Running existing Word macros
• Recording user macros, automatic
• Using the IDE to modify recorded macros and create new ones
• Subroutines and other essential VBA concepts
• Adding repetition (looping)
• Single-action macros and multiple-action macros
• Getting to know the essential Word objects: Words, Paragraphs, Fields, and others
• Formatting tables (Borders, Heading rows, Row breaks, Table Properties attributes)
• Resizing figures
• Adding macro shortcuts to your document
• Macro security levels
• Screen tips
• Using the IDE to watch your macro run from the inside

About the Instructor