Export Task / Week / Resource / Work data into Excel

[Terry Mc]

Not real well versed in VBA, but I need to be able to export data out
of project in the following format (note: resources have names but #'s
are there for demo purposes):

WBS Week Resource Work


1.1.1 9/4/2006 1 25
1.1.1 9/4/2006 2 25
1.1.1 9/4/2006 3 30
1.1.1 9/4/2006 4 40
1.1.1 9/4/2006 5 15
1.1.1 9/11/2006 1 20
1.1.1 9/11/2006 2 40
1.1.1 9/11/2006 3 40
1.1.1 9/11/2006 4 35
1.1.1 9/11/2006 5 30
1.1.1 9/18/2006 1 24
1.1.1 9/18/2006 2 18
1.1.1 9/18/2006 3 9
1.1.1 9/18/2006 4 1
1.1.1 9/18/2006 5 6
etc etc etc etc


I have an existing Access database that will use the planned work
schedules from project to compare to our actual hrs enterered into our
online timekeeping system. At this point, if I can get the info out of
Project and into Excel in this format, I can do the types of analysis
that I need done. I realize that I could do more to make this easier,
but any help at just getting this information out would be greatly
appreciated.

 

[John]

Not real well versed in VBA, but I need to be able to export data out
of project in the following format (note: resources have names but #'s
are there for demo purposes):

WBS Week Resource Work


1.1.1 9/4/2006 1 25
1.1.1 9/4/2006 2 25
1.1.1 9/4/2006 3 30
1.1.1 9/4/2006 4 40
1.1.1 9/4/2006 5 15
1.1.1 9/11/2006 1 20
1.1.1 9/11/2006 2 40
1.1.1 9/11/2006 3 40
1.1.1 9/11/2006 4 35
1.1.1 9/11/2006 5 30
1.1.1 9/18/2006 1 24
1.1.1 9/18/2006 2 18
1.1.1 9/18/2006 3 9
1.1.1 9/18/2006 4 1
1.1.1 9/18/2006 5 6
etc etc etc etc


I have an existing Access database that will use the planned work
schedules from project to compare to our actual hrs enterered into our
online timekeeping system. At this point, if I can get the info out of
Project and into Excel in this format, I can do the types of analysis
that I need done. I realize that I could do more to make this easier,
but any help at just getting this information out would be greatly
appreciated.

Terry,
There are a couple of approaches to get what you want. Since you
indicate you are not well versed in VBA, you might want to try the
"Analyze timescaled data in Excel" utility found on the "Analysis"
toolbar. Run it from the Resource Usage view. The resulting worksheet in
Excel will be a slightly different format and will not include the WBS
but you can manipulate the worksheet for your desired format and the WBS
can be brought over with an export map from Project.

The more efficient approach of course is to write a custom VBA macro
that brings over the data and formats it exactly as you want. Depending
on how much experience you DO have with VBA, you might like to go to
fellow MVP, Jack dahlgren's website at:
http://masamiki.com/project/macros.htm
Take a look at Jack's macro called "Export hierarchy to Excel". It will
require some modification to get what you want but the basics are there.

If modifying Jack's code is a little to adventuresome for you, you may
write to me direct and we can go from there. My address is below.

John
Project MVP
jensenj6atatcomcastdotdotnet
(remove obvious redundancies)