Word 2003: VBA

Course Overview

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.

Audience

Anybody that wishes to understand Visula Basic.

Skills Gained

Delegates will understand how 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.

Prerequisites

Delegates should have working knowledge of Microsoft Word prior to attending this course, or have a similar level of knowledge. No previous programming knowledge is assumed but would be useful.

Course Outline

Unit 1: Getting started with the Visual Basic Editor

• Topic A: Visual Basic for Applications
• Topic B: Properties and modules
• Topic C: The Code window
• Topic D: The Object Browser

Unit 2: Programming basics

• Topic A: Working with variables and functions
• Topic B: Scope of variables
• Topic C: Scope of procedures

Unit 3: Word objects

• Topic A: Programming with objects
• Topic B: The Documents collection
• Topic C: The Tables collection

Unit 4: Control structures

• Topic A: Using decision structures
• Topic B: Using loop structures

Unit 5: Forms

• Topic A: Working with forms
• Topic B: Using events in forms
• Unit 6: Debugging and error handling
• Topic A: Errors
• Topic B: Debugging
• Topic C: Error-handling

Word 2003: VBA / DWD03VBA