Category Archives: VBA

Importing Files to Project Online with VBA

Posted on December 12, 2012 by

In yesterday’s post, I talked about how to run a script to export all of our Microsoft Project schedules into XML files.  In this post, I’ll provide the script to import these into a new instance of Project Server – … Continue reading →

Posted in Admin, Project Online, VBA | Leave a comment

Exporting MPP Files with VBA

Posted on December 11, 2012 by

Well, I didn’t deliberately intend to get into a VBA rut, but periodically, I like to clean out some of the half written posts I have lying around, and it turns out that I apparently left a couple VBA posts … Continue reading →

Posted in Admin, Project Online, VBA | 1 Comment

Flagging Project Owner Changes with OData and VBA

Posted on December 8, 2012 by

This question comes up in the forums pretty frequently, and in fact, I’d actually spec’d out a similar procedure for on-prem Project Server installs which involved hitting the Reporting Database to figure out the Project Owner.  I am not sure … Continue reading →

Posted in Project Online, VBA | 1 Comment

Task Paths in Project 2013

Posted on September 20, 2012 by

Here’s probably one of the most interesting new features (well, other than reporting) added to the new Microsoft Project desktop client – the Task Path feature.  This feature allows you to easily review a schedule to assess the impact of … Continue reading →

Posted in Project Desktop, VBA | Tagged , | 4 Comments

Project VBA and Azure: Better Together

Posted on May 22, 2012 by

I know what you’re all thinking.  Project 2010 is fantastic – and we can’t wait till we get to see the next version.  The only problem is that there’s this one critical function that Microsoft really needs to bake into … Continue reading →

Posted in Project Desktop, VBA | Tagged , | 5 Comments

Revisiting Project Trend Analysis and Project Change Logs

Posted on May 17, 2012 by

The question always arises as to how to best take a snapshot of project data, and use that in timephased reports or change logs.  In fact, by my count, this is the third time I’ve addressed this topic in this … Continue reading →

Posted in BI, Project Desktop, Reporting, VBA | Tagged | Leave a comment

Storing Custom Timescaled Data with VBA

Posted on March 26, 2012 by

Regular readers of this blog may recall a series of posts from January where I discussed how to use VBA to store timescaled BCWP values in the Baseline10Cost field.  At the time, I’d mentioned that the same technique could be … Continue reading →

Posted in BI, VBA | Tagged | 1 Comment

Defining the Ready To Work Metric

Posted on February 24, 2012 by

A little more VBA from my recent foray into the world of ERP cutover scheduling.  In this case, we had a complicated schedule with many predecessor and successor relationships.  The challenge was to develop a metric to indicate when, in … Continue reading →

Posted in VBA | Leave a comment

Find UID Utility

Posted on February 17, 2012 by

Hey folks…sorry for being gone so long.  Been a bit busy managing the schedule for an ERP cutover.  Figured I’d post a little VBA utility that I wrote to help navigate the schedule. As many of you probably know, it’s … Continue reading →

Posted in VBA | Leave a comment

Capturing Custom Timescaled Data in Project Server (Part IV)

Posted on January 19, 2012 by

With this post, we’re pretty much at the finish line.  Now that we have the macro, the baseline mechanics, and the query all figured out, it’s time to flex those Excel muscles and see if we can’t generate a report … Continue reading →

Posted in BI, VBA | Tagged | 1 Comment