VBA Programming for Microsoft Project: Versions 98 Through 2007
Part Two: Advanced Project VBA
Course Overview
This course is designed to give you a great head start with VBA programming in Microsoft Project and is applicable to all releases
from version 98 through 2007. Learn with Rod Gill, one of the world’s foremost Project VBA experts,
live over the Internet in four half-day sessions for Exploring Advanced Project VBA delivered one week after the Intro course
over four half-day sessions.
Target Audience
The target audience for this course is beginners to advanced VBA programmers.
Pre-Requisites
Prior to taking this course, you should take Part One: Intro to VBA unless you already
possess basic VBA programming skills.
This is a course where the more you know beforehand, the more you are likely to learn
during the course. The ideal preparation, therefore, is to experiment with recording
and creating macros or playing with and editing an existing macro.
Get clear what it is you want to be able to do after the course and what sort of macros you want to work on.
We’ll focus more time in student’s expressed main areas of interest and much less on other areas. Please communicate what's most important for you to your training advisor.
Finally, come to class with a macro you need to develop during and after the course. Make sure that you also have time allocated between sessions and after the course to practice and use what you learn.
Learning Objectives
After completing this course, you will be able to:
- Build, edit, and use some very productive macros included with the course material.
- Use your class workbook to find the answers to many common questions and problems.
- Work with Microsoft Project databases and know when and how to use it.
- Create VBA macros in Excel to report on information in Project Server databases. (Note: If you do not have Microsoft Project Server, then you can spend this time can working on other macros with the instructor's help.)