Export Task / Week / Resource / Work data into Excel

[Terry_McCann09]

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.

 

[Mike Glen]

Hi Terry,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP