Hi - I'm trying to copy the dates for a series of identical tasks within several mpp files into an excel sheet. I have now hit a wall and I'm wondering whether what I am trying to achieve is possible.

I want the code to copy the corresponding start and finish date (based on the text in the Task Name column from the mpp file to the corresponding column in excel - which is named the same as the Task Name in the mpp file - except that either 'Start' or 'Finish' is appended to the Task Name.

Example mpp file data:

Task Name | Start Date | Finish Date
Task No1 | 01/12/2008 | 10/12/2008
Task No2 | 09/01/2009 | 20/01/2009
Task No3 | 08/02/2009 | 19/02/2009
etc...

Example xls file following copied data:

Ref | Task No1 Start | Task No1 Finish | Task No2 Start | Task No2 Finish etc...
123 | 01/12/2008 | 10/12/2008 | 09/01/2009 | 20/01/2009 | etc...

The Ref inserted into the excel file will be taken from the first few characters of the mpp filename.

Has anyone had any luck trying to do something similar or does this sound too ambitious? I'd really appreciate any advice or sample code that anyone can suggest as I'm at a loss.

Thanks for looking.

cheers,
rrenis