98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Resourcing sheet
Resourcing sheet
Resolved · Medium Priority · Version 2010
Matthew has attended:
Project Introduction course
Project Intermediate course
Resourcing sheet
Is it possible to run a report that shows the resource allocation as a diary form in Excel wihtout perfomring loads of formatting manually?
RE: 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
Wed 1 Aug 2012: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:MS Project 2010 Scroll to TaskEver feel lost on a large project file? In Gantt view, Task ribbon, Editing, click on the Scroll to Task tool to centre the task bar on your screen. |