Hi Keith - thanks again for posting your code. I've had chance to have a proper look at it now and managed to get it working OK by adding xlbook.save to the end of the code and also set fso and xlapp to nothing to stop excel from hanging.

I didn't explain it too well previously as I was trying to contain all of the data from the mpp file in 1 row within excel. Hopefully the following illustrates this better...

All of the following to be contained on 1 row:

Column A = Reference (obtained from first few characters of filename)
Column B = Task 1 Start Date
Column C = Task 1 Finish Date
Column D = Task 2 Start Date
Column E = Task 2 Finish Date
Column F = Task 3 Start Date
Column G = Task 3 Finish Date
etc...

I was hoping to have Row 1 as the header (the column header will be identical to the corresponding task but appended by either start or finish). Ideally I would like to use some kind of text compare to verify that the data is going in the right place.

The code you've provided so far is great as it gives me something to work on. I'd appreciate any advice as to whether you feel what I've outlined above is a step too far or a real possibility (I've taught myself VBA from googling and reading through this site so I have some sizable gaps in my knowledge! ).

Thanks again for your code

cheers,
rrenis