Export Task Information to Excel   

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

date: Tue, 22 Jul 2008 04:08:00 -0700   author:   TonyK

Re: Export Task Information to Excel   

In article ,
 TonyK  wrote:

> 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

date: Tue, 22 Jul 2008 08:47:12 -0700   author:   John

Re: Export Task Information to Excel   

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


"John" wrote:

> In article ,
>  TonyK  wrote:
> 
> > 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
>

date: Wed, 23 Jul 2008 02:53:00 -0700   author:   TonyK

Re: Export Task Information to Excel   

In article ,
 TonyK  wrote:

> 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

TonyK,
You're welcome and thanks for the feedback.
John
Project MVP
> 
> 
> "John" wrote:
> 
> > In article ,
> >  TonyK  wrote:
> > 
> > > 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
> >

date: Wed, 23 Jul 2008 07:48:41 -0700   author:   John