Summary tasks from Project To excel

[Esperanza]

Hello, I currently have a timesheet that exports info from Project
into Excel. I a having trouble displaying second level summaries. I
can easily get teh first summary level up from the task but I was
wondering if it is even possible to get the second level?

 

[John]

Esperanza,
There are several ways to export data from Project to Excel. Since you
are talking about time related data, I will assume you are using the
"analyze timescale data in Excel" add-in. And since you refer to
multiple summary levels, I will assume you are NOT exporting from the
Resource Usage view.

If you are exporting from the Task Usage or Gantt Chart, all summary
levels do show up in the export, they just do not have values.

To answer your question directly, yes it is possible to export timescale
data from Project to Excel including values at all levels. However, it
requires a custom VBA macro.

John

 

[Esperanza]

To make it clearer, right now I have a custom macro that has this line
of code in it:
xlR.Range("B1") = A.TaskSummaryName

This gives me the task summary name at the previous level, but I also
want the next summary at the next level(its a hierarchy) and this is
what I cant get.

 

[Jan De Messemaeker]

A.Outlineparent.outlineparent.name
HTH