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.
Are they updating Microsoft project Client or Project Server? -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "William Busby" schreef in bericht news:9Gpqf.82$Z95.1@fe04.lga... > 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. > >
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" <jandemes at prom hyphen ade dot be> wrote in message news:OjNucvsBGHA.4016@TK2MSFTNGP11.phx.gbl... > Are they updating Microsoft project Client or Project Server? > > -- > Jan De Messemaeker > Microsoft Project Most Valuable Professional > http://users.online.be/prom-ade/ > +32-495-300 620 > "William Busby" schreef in bericht > news:9Gpqf.82$Z95.1@fe04.lga... >> 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. >> >> > >
Sorry, I don't know Server. Best is to repost in the .developer newgroup, there are a few Server guys around there. Greetings, -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "William Busby" schreef in bericht news:qjyqf.169$5R3.69@fe02.lga... > 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" <jandemes at prom hyphen ade dot be> wrote in message > news:OjNucvsBGHA.4016@TK2MSFTNGP11.phx.gbl... > > Are they updating Microsoft project Client or Project Server? > > > > -- > > Jan De Messemaeker > > Microsoft Project Most Valuable Professional > > http://users.online.be/prom-ade/ > > +32-495-300 620 > > "William Busby" schreef in bericht > > news:9Gpqf.82$Z95.1@fe04.lga... > >> 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. > >> > >> > > > > > >
