Demystifying Macros and VBA: The Secrets of Automating Word

This 1-day in-depth Visual Basic for Word Macros seminar is designed to give you the tools for creating macros that can automate and speed up mundane, repetitive tasks. Understanding the essentials of Visual Basic as used in creating Word macros can lead to increasing your working accuracy and efficiency, and help to standardize the look of your documents. Learn the power of VB to create efficient macro to make sophisticated, repetitive changes at the click of a button.

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.

Topics include:

  • Running existing Word macros
  • Recording user macros, automatic repetition (looping), macros for extending Word functionality
  • Using the IDE to modify recorded macros and create new ones
  • Subroutines and other essential VBA concepts
  • Programming a loop
  • 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
  • Finding and modifying fields
  • Adding macro shortcuts to your document
  • Macro security levels
  • Screen tips
  • Using the IDE to watch your macro run from the inside
  • Setting IDE breakpoints

About the Instructor

Avraham Makeler is a software engineer come technical writer and has been programming Word macros and applications for a number of years. Avraham's programming background allows him to add a whole new dimension to Microsoft Word, making it truly dance and sing. Avraham teaches a variety of programming-related seminars at WritePoint.