Microsoft Word 2007 VBA Programming

	This course is designed to give proficiency in the Visual Basic Editor (VBE), Word objects, basic VBA programming, control structures, debugging tools, advanced VBA programming, and event handling.
	Duration: 1.0 day(s) Price: £218.00 + VAT	Download Course Content   Download Course Files

Locations

Infero Ltd is based in the Lace Market in Nottingham. Training courses take place at the following locations including Nottingham, Derby, Loughborough, Mansfield, Chesterfield, Burton-on-Trent, Lincoln, Leicester, Sheffield, Stoke-on-Trent, Tamworth, Wolverhampton, Walsall, Birmingham, Solihul, Coventry, Nuneaton, Peterborough, Grantham.

Target Students

Advanced Microsoft Word professionals who need to automate Word tasks using Visual Basic for Applications (VBA).

Prerequisites

To ensure your success we recommend that you are able to do the following:

• Navigate, edit and manage Word documents
• Create and modify Word tables
• Understand programming concepts
• Understand Macro concepts
• Awareness of the VBA development environment

Delivery Method

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Course Objectives

Upon successful completion of the course, students will be able to:

• Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures.
• Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope.
• Work with VBA objects; create, open, save, and close documents by using a Document collection; create a table by using the Tables collection; and work with the Table object.
• Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks.

Course Content

Lesson 1: Getting started with the Visual Basic Editor

Visual Basic for Applications.
Properties and modules.
The Code window.
The Object Browser.

Lesson 2: Programming basics

Working with variables and functions.
Scope of variables.
Scope of procedures.

Lesson 3: Word objects

Programming with objects.
The Documents collection.
The Tables collection.

Lesson 4: Control structures

Using decision structures.
Using loop structures.

Lesson 5: Forms

Working with forms.
Using events in forms.

Lesson 6: Debugging and error handling

Errors.
Debugging.
Handling errors.