Word 2007 VBA

Target Audience

Experienced users of Word who need to develop and enhance their expertise. In particular, delegates should be confident with the fundamental techniques of Word and have a thorough knowledge of templates, styles and fields.

Pre-requisites

To fully benefit from this course, attendees are expected to be confident users of Word and be familiar with the topics covered in the Word Foundation and Intermediate courses.

On completion of the course, delegates will be able to:

• Create macros in Word
• Understand the Word object model and VBA concepts
• Work with the main components of the VBA Editor window
• Create command procedures
• Create and use variables
• Create and work with functions
• Use decision structures to control the outcome of your program
• Use looping structures to repeat sections of code
• Work with text using a range of objects
• Customise the way files and folders are managed
• Create a custom form complete with controls and event procedures
• Create code to drive a UserForm
• Write a variety of error handling routines
• Use Word's built-in dialog boxes

Macros

Understanding Word Macros • Setting a Macro Security Level • Recording a Simple Macro • Running a Macro • Assigning a Macro to a Toolbar • Modifying a Macro Tool  • Assigning a Macro to a Menu • Assigning a Macro to a Shortcut Menu • Creating a Custom Pull-Down Menu • The Many Ways of Running a Macro  • Editing a Macro  • Deleting a Macro  • Removing References to Macros • Creating a Macrobutton Field  • Tips for Developing Macros

Understanding VBA

VBA Terminology • Accessing the Word Object Model • Using the Immediate Window  • Working with Object Collections • Setting Property Values  • Using the Object Browser  • Programming with the Object Browser

Using the VBA Editor

Opening and Closing the Editor  • Working with the Project Explorer • Working with the Properties Window • Working with the Work Area • Working with a Code Module  • Running Procedures from the Editor

Procedures

Creating a Command Procedure  • Making Sense of IntelliSense • Using the Edit Toolbar • Commenting Statements  • Indenting Code • Bookmarking in Procedures

Using Variables

Creating & Using Variables • Implicit and Explicit Declarations • The Scope of Variables  • Procedure Level Scoping  • Module Level Scoping  • Passing Variables by Reference • Passing Variables by Value  • Data Types • Declaring Data Types  • Using Arrays • Using Intrinsic Constants

Functions

Functions Theory • Creating & Calling Functions • The MsgBox Function • Sending Messages to the User • Input Techniques  • Using the InputBox Function  • Nesting Functions  • Using Functions in Function Procedures

Decision Structures

The If Statement • Using If for Single Conditions  • Using If for Multiple Conditions • The Select Case Statement • Using the Select Case Statement • Using Select for Sets of Values • Using Select for Ranges of Values

Looping Structures

For Loops • Looping for Each Item • Adding an Exit to a Loop • The Do Loop Statement • Looping with Unknown Iterations

Working with Text

Text & Document Components • The Story Range • The Selection Object  • Using the Selection Object • The Range Object  • Using Range Objects • The Find Object

Document Management

The Activate Open & Close Methods • Opening & Closing Documents  • The Add Method • The Save & SaveAs Methods • Properties that Return Information • Functions that Return Information • Files Folders & Drives • Working with Files & Folders • Removing Files & Folders  • The Application & Options Object

Creating Custom Forms

Creating A Custom Form • Adding Text Boxes to a Form • Adding Label Controls to a Form • Changing Text Box Control Properties • Adding a Combo Box Control  • Adding Option Buttons • Command Buttons • Changing the Appearance of Controls • Running a Custom Form

Programming UserForms

Initialising A Form  • Closing a Form • Creating Functions for a Form • Coding Option Buttons  • Setting Bookmarks for Data Entry • Setting the Tab Order  • Forcing Correct Entry • Templates and AutoStart Macros • Creating a Template with AutoMacros

Error Handling

Error Types • The On Error Statement  • Creating a Simple Error Handler  • Using the Resume Statement • Using Decision Structures in Error Handlers • Defining Custom Errors

Built-in Dialogs

The Dialogs Collection • Dialog Box Arguments • Using the Execute Method • Using the Show Method  • The Display Method

You may also be interested in some of the following related courses below:

Microsoft - Word 2007 - Foundation
Microsoft - Word 2007 - Intermediate
Microsoft - Word 2007 - Power User

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.