ID for External task?

[pearl]

Hallo,

I am probably just plain stupid, but can anyone please help me with
this one?

Having a main project with 6 subprojects.
The 6 subprojects have some tasks linked between one another.
Using VBA, I would like, when I find an external task, to know its own
ID (in its own subproject)
Using <myTask.Project> will give me the name of the subproject, but
how do I get the ID?

Thankfull for all help!
Pearl

 

[John]

Hallo,

I am probably just plain stupid, but can anyone please help me with
this one?

Having a main project with 6 subprojects.
The 6 subprojects have some tasks linked between one another.
Using VBA, I would like, when I find an external task, to know its own
ID (in its own subproject)
Using <myTask.Project> will give me the name of the subproject, but
how do I get the ID?

Thankfull for all help!
Pearl

Pearl,
First of all you are not stupid. What's stupid about a perfectly valid
question? C'mon, give yourself some credit for knowing when to ask.

Be advised that you may not always see external tasks in a master file
even if the option to show external predecessors and successors is
checked (Tools/Options/View tab).

Although what you are asking for may seem pretty basic, finding the ID
of the external tasks is not a trivial process. It can be done but the
best process for doing so depends on your end goal. What exactly is your
end goal? Let's start with that and then go from there.

John
Project MVP

 

[pearl]

Hallo John,

Thanks for your interest!

I bought Rod Gills book and read it this summer. Excellent book!
Rod has a great form to find what is driving your task, with
pedecessors and successors in a list.
I have extended the form so that it is possible to select a successor
in the list and then use the GoTo-button to go directly to the task.

So practically, I want to be able to see the external tasks successors
in the list in the form, that is its successors in its own project.

Knowing its ID, it would be no problem to get the successors and
predecessors...

//Pearl

 

[Rod Gill]

Well, after that review I just have to bust in: thanks Pearl!

When you look at the dummy Task inserted when you link two tasks in
different projects, when the other project is closed, the predecessors
column holds the path to the other project and it's unique ID. The External
field will also have a value of Yes.

So to get the predecessors of the task in the other project, you would have
to open it then get the predecessors of the task with the unique ID from the
first project.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[John]

Well, after that review I just have to bust in: thanks Pearl!

When you look at the dummy Task inserted when you link two tasks in
different projects, when the other project is closed, the predecessors
column holds the path to the other project and it's unique ID. The External
field will also have a value of Yes.

So to get the predecessors of the task in the other project, you would have
to open it then get the predecessors of the task with the unique ID from the
first project.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Rod,
I'm a little confused by your second paragraph and I think something
needs a little clarification. When looking at the Predecessor or
Successor fields, an external task will be displayed with the path and
the task ID of the external task. In order to see the path and Unique ID
of the external task, the user must look at the Unique ID Predecessors
and Successors fields.

Hope I didn't misunderstand.

John
Project MVP

 

[John]

Hallo John,

Thanks for your interest!

I bought Rod Gills book and read it this summer. Excellent book!
Rod has a great form to find what is driving your task, with
pedecessors and successors in a list.
I have extended the form so that it is possible to select a successor
in the list and then use the GoTo-button to go directly to the task.

So practically, I want to be able to see the external tasks successors
in the list in the form, that is its successors in its own project.

Knowing its ID, it would be no problem to get the successors and
predecessors...

//Pearl

Pearl,
You're welcome. Since Rod jumped in I'm going to let him handle this one.

John
Project MVP

 

[Rod Gill]

I did a quick test to confirm before I posted, and I got the file path and
name in the normal Predecessor column. I would expect it in the unique ID
column as well.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[pearl]

Hallo Rod and John,

Well it works fine now.
Thanks for the help!

//Pearl

 

[John]

I did a quick test to confirm before I posted, and I got the file path and
name in the normal Predecessor column. I would expect it in the unique ID
column as well.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Rod,
Yes, the full path will appear in both types of fields. My point of
clarification was this. The normal Predecessors and Successors fields
will contain the external task path and task ID (not Unique ID). The
Unique ID Predecessors and Successors fields will contain the external
task path and task Unique ID.

At any rate, the poster apparently got it all working so all is well.

John