resourcing sheet

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Resourcing sheet

Resourcing sheet

resolvedResolved · 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.


 

MS Project tip:

MS Project 2010 Scroll to Task

Ever 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.

Shortcut Ctrl+Shift+F5

Same as Go to Selected Task in MS Project 2003.

View all MS Project hints and tips


Server loaded in 0.06 secs.