Checking the nth row of task... Help!

[ronald_yoh]

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.............

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" <ronald_yoh.3c1zjd@DoNotSpam.com> 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/members/52542.htm
> View this thread: Checking the nth row of task... Help!
>
> http://forums.techarena.in
>

[ronald_yoh]

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

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" <ronald_yoh.3c2lrc@DoNotSpam.com> 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/members/52542.htm
> View this thread: Checking the nth row of task... Help!
>
> http://forums.techarena.in
>

[ronald_yoh]

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

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" <ronald_yoh.3c5zzc@DoNotSpam.com> 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/members/52542.htm
> View this thread: Checking the nth row of task... Help!
>
> http://forums.techarena.in
>

[ronald_yoh]

hi Rodd... i've been using the "display alert" but it won't solve the issue from prompting "open the resource pool" since the prompt happens when you open the application file (at this point you do not have access to the file).

Cheers
Ron

[ronald_yoh]

Hi Rodd.. don't worry about my previous reply.. I sorted it out.. didn't realise the openfile has option to prompt.

Ta