Jack's Macro - Resources

[James]

Hi all,

I have another query with Jack's Fab Macro.

Some of the tasks in my plan have more than one resource name against them,
as they require input from more than one person (we are truely a
cross-functional team!).

However, when the export runs, it only leaves one name in the field. It
looks like it applies the first name assigned to the task, then overwrites
with the second.

Is there a way to adjust the code so that it outputs multiple resource names?

Thanks!
James

 

[John]

Hi all,

I have another query with Jack's Fab Macro.

Some of the tasks in my plan have more than one resource name against them,
as they require input from more than one person (we are truely a
cross-functional team!).

However, when the export runs, it only leaves one name in the field. It
looks like it applies the first name assigned to the task, then overwrites
with the second.

Is there a way to adjust the code so that it outputs multiple resource names?

Thanks!
James

James,
Jack may be offline for a few days - I haven't seen him post for a
while. Let's see if we can help. First of all I assume the "Jack's fab
macro" you are referring to is his "Export hierarchy to Excel". If not,
which macro is it?

If you've modified Jack's code you may have created a problem. As
written, the macro does export all resources assigned to a given task.
However, those resources are shown in separate rows in Excel instead of
as a delimited string as seen in Project.

John
Project MVP

 

[James]

Thanks John,

Yes, I am talking about Jack's Export Heirarchy macro.

I have modified it slightly. I have added in a couple of fields that I want
exporting, and also removed the 'dwn 1' command so that the data was on the
same row as the task name as it appears in Project.

I will try putting this line back in, and if that doesn't work, I will look
again at an unmodified version to try to figure it out.

I'll post back to let you know how I got on.

Thanks!
James

 

[James]

Thanks for your pointers, they really helped.

I now have a report that exports straight from Project without any seond
touching. I played around with the location of the "dwn" function, and added
in a variable count within the 'Each Asgn' loop, so that it puts task details
in one row only, and then adds in the resources in following lines as per
Jack's original.

I have also added in a sub routine for some extra formatting. This was a
Macro developed in Excel, but required a save, close and open before it
worked. I copied the code into project and get two for one. The only thing I
cannot get it to do is to freeze panes. The command for the excel macro
doesn't work in the project code.

But this will still keep my team happy!

Thanks again!
James