MS Word VBA Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

The Microsoft Word VBA training course provides skills to automate MS Word tasks using Visual Basic for Applications (VBA). You will record VBA macros and then learn to create and work with modules, procedures, variables and constants in the Visua Basic Editor. Using many different samples, you will also create if statements, loops and dialogs.

By attending Microsoft Word VBA workshop, delegates will learn to:

Getting Started with the Visual Basic Editor
Exploring Word Visual Basic for Applications (VBA)
Properties and Modules
The MS Word VBA Code Window
The Object Browser
Basic Programming Concepts
Working with Variables, Procedures and Functions
Programming with MS Word Objects
The Documents and Tables Collections
Using Loop Structures
Using Decision Structures (If, Then, Else, etc.)
Working with Forms & Form Events
Handling Errors
Debugging Errors

Experience with Word 2007 or higher

The Microsoft Word VBA class is intended for analysts, business intelligence (BI) developers and IT professionals

Overview of VBA Macro Concepts

What is a VBA macro?
Displaying the Developer tab in Microsoft Word
Creating macros using the macro recorder in Microsoft Word
Limitations of recorded macros
Saving files with macros

Working with the Visual Basic Editor (VBE)

Opening and closing the VBA editor
Using the Project Explorer and the Code Window
Moving between Microsoft Word and the VBA editor
Overview of the properties window and the work area
The basics of writing code

Macro Security and Trust Centre Settings

Specifying macro security settings
Creating a trusted folder

Getting Started with VBA

Basic syntax logic
Sub procedures
Naming macros
Working with modules and projects
Using methods and properties
Adding comments

Running Macros

Running macros using the keyboard and the Macro dialog box
Running macros using buttons

Procedures

Sub procedures
Running procedures within other procedures

Variables and Constants

Using constants and variables
Types of variables
Constant and variable declarations
Declaring several variables
Procedure level scope, module level scope or public scope

Decision Structures

Writing If statements
Using If for single and multiple conditions

User Interaction

Overview of the dialogs collection
Using input boxes and extracting answers
Using message boxes for input
Specifying status bar messages
Using dialog box arguments
Using the Execute, Show and Display methods

Looping Structures

Looping for items
Adding an exit
Using the Do Loop statement

Working With Text

Text and document components
Using the story range
Using the selection and range objects
Inserting text

Document Management

Using opening and closing methods
Using the Save and SaveAs methods
Returning and retrieving information
Referencing files, folders and drives

Error Handling

Types of errors
Simple error handling
Resuming macros
Decision structures when dealing with errors

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

MS Word VBA

COURSE AGENDA