Word VBA Training

Our Word VBA course is designed to get participants up to a level where they can confidently code Word VBA solutions for themselves.

We cover all the basic skills required and culminate in the the creation of a template, such as a Letter, with an advanced custom front-end dialog, eg:

Letter Template example

The course can be focused on Word 2000, XP or 2003.

Who is the course for?

We tailor the course to meet the participant's level of experience. We can start with complete beginners and cover the basics of programming or we can take experienced VB programmers through to advanced topics.

The course is hands-on with each participant at a PC where together we code VBA solutions that can be taken away. Class notes are provided.

We supply up to three days of training, each being available separately. The first 2 days of which is enough to get participants up and running with VBA.

We encourage participants to bring along their own projects so that we can both tune the training even more closely to their requirements and give them a helping hand with the project.

Location and Costs

We provide training at your company premises or at our training facility in Southampton. Training can be on a one-to-one basis or classroom based with up to 6 participants. As yet we do not provide public VBA courses.

For training at your site the cost per day is £600 + £50 per attendee + travel expenses + VAT. (For a days training in London for 3 people this equates to £600 + £150 + £60 = £810 + VAT)

For training at our facility in Southampton the cost per day is £700 + £50 per attendee + VAT. This includes lunch and refreshments, the training facility has a hotel next door.

Post-training support

We provide telephone and email support to our participants following their training. A few words from an expert can be a great help in developing VBA solutions. We also write VBA code on a consultancy basis.

Course Description

Days	Topics covered
Day 1	Templates explained VBA development environment Create, edit, debug VBA code 'Record-and-help' code generation Customize toolbars, menus and keystrokes Introduction to the Word Object Model Simple custom forms - a Letter template
Day 2	Advanced Word Object Model Selection vs Range Collections Advanced letter template dialog Run other Office applications Installing and running Word over a network Global add-in templates
Day 3	Command bars, Office Assistant COM addin designer Class Modules Application Events Database access: DAO, ADO Windows API calls Smart Tags

To find out more call Chris Devrell on +44 (0)2380 74 0990 or email: chris@cdev.co.uk.