Export Task Information to Excel

[TonyK]

Hi
I am using the code kindly made available by Jack Dahlgren to export certain
data to Excel. I am exporting Milestone information to a spreadsheet however
on some of the milestones it is only exporting the milestone name and not the
following fields I have requested:
Milestone
Work
Actual Work
Duration
Baseline Start
Actual Start
Baseline Finish
Actual Finish
It should be noted that the first two milestones within the range I am
exporting contains this information.
I have checked the MSP Plan and the information is there.
In summary I am exporting milestone for the month of July and there are
seven of them. Two of them contain all the information (the first two). The
remaining 5 only contain the milestone name.
Any advice would be appreciated.

 

[John]

Hi
I am using the code kindly made available by Jack Dahlgren to export certain
data to Excel. I am exporting Milestone information to a spreadsheet however
on some of the milestones it is only exporting the milestone name and not the
following fields I have requested:
Milestone
Work
Actual Work
Duration
Baseline Start
Actual Start
Baseline Finish
Actual Finish
It should be noted that the first two milestones within the range I am
exporting contains this information.
I have checked the MSP Plan and the information is there.
In summary I am exporting milestone for the month of July and there are
seven of them. Two of them contain all the information (the first two). The
remaining 5 only contain the milestone name.
Any advice would be appreciated.

TonyK,
Just for reference, there should be no work, actual or otherwise,
associated with a milestone. A milestone by definition is a "0" duration
event that marks the start of a group of tasks or the completion of a
group of tasks. It is either complete or not complete - there is no
partial completion of a milestone.

With regard to using Jack's macro, I assume you are using his "export
hierarchy to Excel" code that has been modified to include the extra
fields. Unless a task has resources assigned, Jack's code will only
export the task name - that may be why you only see task name
information for some milestones. You can further modify the code to
include all the data you want by writing Project data outside the
assignment loop.

Hope this helps.
John
Project MVP

 

[TonyK]

Hi John
Now I understand why it is not printing detail for all milestones.
You can tell I am NOT a programmer can't you.
Many thanks for your help.
Kind regards

 

[John]

Hi John
Now I understand why it is not printing detail for all milestones.
You can tell I am NOT a programmer can't you.
Many thanks for your help.
Kind regards

TonyK,
You're welcome and thanks for the feedback.
John
Project MVP