Resourcing sheet

Hi Matt. I think you're almost certainly looking at a VBA solution to this, probably automating a process similar to this one, but exporting (and automatically formatting) out to a spreadsheet:

http://www.applepark.co.uk/exporting-tasks-from-project-into-your-outlook-calendar/

There are some third party tools such as:

http://www.projectinsight.net/project-management-software/manual/helpfile.htm #faq/microsoft-project-import-export.htm

...which claims:

"Project Insight does however export the resources’ work calendars upon export"

...although they want you to buy the product to discover exactly what format it dumps the data out in!

If I was in your shoes and the formatting process ate up a lot of your time I'd definitely go down the code route. I reckon you could probably build that yourself, but if you need help talk to our enquiries team and we'll build it for you and walk you through the code.

All the best,

Anthony