How to select a task when a filter...

[Woody]

Hi,
How can we select a task (with VBA) the TaskID of which is 10, when a filter
is applied and this task is, may be, the 7th in the list of tasks ?
Thanks for your help!

 

[John]

Hi,
How can we select a task (with VBA) the TaskID of which is 10, when a filter
is applied and this task is, may be, the 7th in the list of tasks ?
Thanks for your help!

Woody,
Simple as this may seem, Project's object library does not have a direct
way of selecting a specific task object in a filtered view. The best I
can come up with is to use the Find Method. The syntax could be:

Find Field:="ID", Test:="equals", Value:="10"

Hope this helps.
John
Project MVP

 

[Woody]

Thanks a lot for the trick, John.

Woody

Woody,
Simple as this may seem, Project's object library does not have a direct
way of selecting a specific task object in a filtered view. The best I
can come up with is to use the Find Method. The syntax could be:

Find Field:="ID", Test:="equals", Value:="10"

Hope this helps.
John
Project MVP

 

[John]

Thanks a lot for the trick, John.

Woody

Woody,
You're welcome.
John