Manipulating data in MSP 2003 via VBA code

[Dave]

I am looking for help or examples on writing a project VBA application that
would do the flowing:

I need to take the Resource Time Scaled data from the BaselineWork fields
and copy/move it into the Resource Time Scaled data of the Work filed. Yes,
just the opposite of saving the Baseline function in project. I have used
the “TimeScaleData†Method to get the data from the BaselineWork filed, but I
do not understand how to get those values into the Work fields. Also I need
to do this for ALL resource in the project from a specific start and end
date. Any help or examples would be great. Thanks Dave Richter

 

[Rod Gill]

Hi,

Obviously this would be run on a copy of your file?!!!

Equally obviously my book has examples of writing timescaled data The
trick is to copy the assignment baseline to assignment data. If a baseline
assignment is 5d and the current is 3d then the assignment either needs to
be made 5d before copying or you need to add 2 day long time slices. If the
task is now 6d then you need to remove the lst day.

This process is difficult with many gotchas. This is also where a good
backup plan is good. Can you not copy the Tasks you want from a restored
copy? That would be significantly quicker and cheaper than developing a
restore baseline macro.

Since you have asked for help here, it suggests you have little VBA
experience. What you want to achieve is do able, but because of all the
little gotchas, unless you have a 100 schedules to restore, a little manual
copying is going to be quicker and cheaper.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com