Loading...
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
1
2
3
4
5
Submit
     
Cancel
Create your own review
MPUG
Average rating:  
 1 reviews
byKarim Bouhlila onMPUG

EVM DASHBOARD AND DATABASE MAKER FOR PROJECTS

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

Customer Reviews

5
0%
4
0%
3
0%
2
0%
1
0%
0
0%

    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>

    Thanks for submitting your comment!