Quick Links

Webinar: What can Project VBA do for you?

Project Management Institute (PMI)® Professional Development Units (PDUs):
This Webinar is not in the PMI® system. However, it is eligible for self-directed learning PMI® PDU credit.

Speakers: Rod Gill, MVP

This one hour session will cover:

• What is VBA?
• Difference between Project VBA and Excel or Word VBA
• Examples of its power
• Skills needed to use it
• Sharing VBA code with other Project users
• Sharing VBA Code via Project Server

For the VBA presentation Rod will be presenting 3 samples as follows:

  1. Event sample: How a macro can automatically move the timescale to today’s date every time you open a project.
  2. S-Curve sample: A popular report on a project is cumulative Work and cumulative Costs against cumulative baseline Work and Cost is called an S-Curve. This Project VBA macro automatically creates an S-Curve in Excel using the active project in Project Professional or Standard.
  3. Project Report in Excel: This Excel VBA macro uses data from Project Server: Summary Task, Milestones, Risks, Issues and Resource Usage across all projects in Microsoft’s demo VPC image.

VBA for Project and Excel is a very powerful tool. This presentation shows in one hour how easy it is to tap into this power using these three samples.

Have you watched this webinar recording? Tell MPUG viewers what you think!

Submit your review
Create your own review
Average rating:  
 1 reviews
 by Karim Bouhlila


Product Overview :
EVM Dashboard is a project performance indicator monitoring solution intended for Project Management Officers (PMO). It is based on the Earned Value Management method. From data extracted from a planning tool (Microsoft Project), EVM Dashboard automatically publishes project performance dashboards. EVM Dashboard is a WEB solution. It includes two modules: “EVM Database builder” which will allow the creation of a project performance database and “EVM Dashboard-viewer” executed by a web browser which will allow the project performance indicators to be viewed.

Written by Community

Where Project Managers and Microsoft® Meet.

Share This Post

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>