Does anyone know how to check the "nth" row of the task. I'm currently working with master project contains the "inserted project" as summary task. As you might have known the ID of the subtask under this summary task will be reset to 1. So writing VBA code: Selecttaskcell Row:=oTask.ID will not solve the issue. Any ideas out there? Help............. -- ronald_yoh ------------------------------------------------------------------------ ronald_yoh's Profile: http://forums.techarena.in/member.php?u=52542 View this thread: http://forums.techarena.in/showthread.php?t=996559 http://forums.techarena.in
Hi, This group is closing soon, so please use the project.programming group in future. You need to open the sub-project using the subproject property, then you can access the task in the sub-project. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com "ronald_yoh" wrote in message news:ronald_yoh.3c1zjd@DoNotSpam.com... > > Does anyone know how to check the "nth" row of the task. > > I'm currently working with master project contains the "inserted > project" as summary task. As you might have known the ID of the subtask > under this summary task will be reset to 1. So writing VBA code: > Selecttaskcell Row:=oTask.ID will not solve the issue. > > Any ideas out there? Help............. > > > -- > ronald_yoh > ------------------------------------------------------------------------ > ronald_yoh's Profile: http://forums.techarena.in/member.php?u=52542 > View this thread: http://forums.techarena.in/showthread.php?t=996559 > > http://forums.techarena.in >
mate.. how stupid that was.. what a shame when you're allowed to insert the project into master but can't manipulate the data in there Thanks anyway.. Ta -- ronald_yoh ------------------------------------------------------------------------ ronald_yoh's Profile: http://forums.techarena.in/member.php?u=52542 View this thread: http://forums.techarena.in/showthread.php?t=996559 http://forums.techarena.in
If you insert the project into the master without the link option you can as all tasks are copied. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com "ronald_yoh" wrote in message news:ronald_yoh.3c2lrc@DoNotSpam.com... > > mate.. how stupid that was.. what a shame when you're allowed to insert > the project into master but can't manipulate the data in there > > Thanks anyway.. > > Ta > > > -- > ronald_yoh > ------------------------------------------------------------------------ > ronald_yoh's Profile: http://forums.techarena.in/member.php?u=52542 > View this thread: http://forums.techarena.in/showthread.php?t=996559 > > http://forums.techarena.in >
hi mate, you're right... 2 more Qs: 1) how do you disable (via VBA) the wizard planning wizard before opening the file? (e.g. avoid ms project to prompt "Open the resource pool to see assignments across all sharer files" while opening the sharer file). 2) how do you force the user to use only resources from resource pool and make sure there is no local resource for each project? Cheers Ron -- ronald_yoh ------------------------------------------------------------------------ ronald_yoh's Profile: http://forums.techarena.in/member.php?u=52542 View this thread: http://forums.techarena.in/showthread.php?t=996559 http://forums.techarena.in
There are flags in the VBA command that do that, see help. The DisplayAlerts method can also hide some messages. You can't force users to only use Pool Resources. You could write an event for each new assignment to test this. I would just make sure someone is responsible for keeping the Resource Pool "clean" and tests at least every month, or that there is an audit process for each new schedule added to the pool. This should also confirm the new schedule does not have resources assigned at 100% unless that is what is really going to happen otherwise the pool data becomes very inaccurate. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com "ronald_yoh" wrote in message news:ronald_yoh.3c5zzc@DoNotSpam.com... > > hi mate, you're right... 2 more Qs: > > 1) how do you disable (via VBA) the wizard planning wizard before > opening the file? (e.g. avoid ms project to prompt "Open the resource > pool to see assignments across all sharer files" while opening the > sharer file). > > 2) how do you force the user to use only resources from resource pool > and make sure there is no local resource for each project? > > Cheers > Ron > > > -- > ronald_yoh > ------------------------------------------------------------------------ > ronald_yoh's Profile: http://forums.techarena.in/member.php?u=52542 > View this thread: http://forums.techarena.in/showthread.php?t=996559 > > http://forums.techarena.in >
