Clear all rate and cost information

[CB]

I am using MSOP 2007 standard.
I need to clear all cost information from the schedules. This includes the
standard rate, actual cost, cost 1 through cost 10 and overtime rate fields.
Does anyone have VBA that can accomplish this automatically?
Thanks,
CB

 

[Jack Dahlgren]

I used to have a file sanitizer macro on my site, but it scrambles names as
well so may not be useful
A simple way to do this is build a view with all the cost fields and then
delete the values by selecting the column and hitting delete. Do this after
you have set resource rates to 0.

Should only take you a couple of minutes.

-Jack Dahlgren

 

[CB]

Thanks for the quick response jack. I have 10 to 15 active PMs/Proj Leads.
It would be much easier to have the VBA and a button on their desk top than
to risk sensitive data going somewhere we don't want it to go.
I'll keep trying to find an automated solution.
CB

 

[Jack Dahlgren]

It is pretty simple to write:

for each resource in activeproject.resources
resource.... = 0
next resource

for each task in activeproject.tasks
task.cost = 0
task.actualcost = 0
....

-Jack Dahlgren