Possible to removing remaining work by resource in VBA?

[William Busby]

I'm new to this and not a full-time VBA developer. I'd like to solve the
issue where you get a message when updating time to a project and you have
inactive resources with work remaining. The message pops up on each update
which for many of our managers makes updating time a tedious process.

I'd like to provide a macro that will go through each resource and determine
if they are inactive. For those that are inactive set their remaining work
(on all assigned tasks) to 0. Does this sound doable? Where would I look for
code examples? I don't mind doing the work to develop this but I've no idea
where to start.

 

[Jan De Messemaeker]

Are they updating Microsoft project Client or Project Server?

 

[William Busby]

We're running Project Server 2003 SP1 (soon to be SP2a). If there were some
way to run this againsts all projects on the server as a scheduled task that
would be (as my kids put it) totaly sweet. If it has to be a macro in the
global template that PM's can run on their local client when a project is
open that would be much better than what we do today (manually hunting for
remaining work or even just removing resources from project files).

 

[Jan De Messemaeker]

Sorry, I don't know Server.
Best is to repost in the .developer newgroup, there are a few Server guys
around there.
Greetings,