Exporting to Excel time scale data

[Newbie MSProj]

Hi,
Can someone please help me on this:
I need a VBA code to export TimeScale Data to Excel.
Scenario:
I have 20 resources and I want to export to Excel their Work Assigment for
all of the following time period:
Period 1: Jan 1 to Jan 25
Period 2: Jan 26 to Feb 22
Period 3: Feb 23 to Mar 28
Period 4: Mar 29 to Apr 21
..
..
..
Period 12: Nov 17 to Dec 31


Final output in Excel table will be like:
Resource Name Period 1 Period 2 Period 3 … etc
Bob 18h 16h 12h
George 24h 20h 19h
Etc



Thanks

 

[Mike Glen]

Hi ,

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

 

[Jack Dahlgren]

Have you read my recent article on exporting resource timescaled data? It
should give you 90% of the code you need.

http://zo-d.com/blog/archives/progr...oft-project-resource-usage-data-in-excel.html

-Jack Dahlgren

 

[Newbie MSProj]

Thanks! I'll give it a shot...

Have you read my recent article on exporting resource timescaled data? It
should give you 90% of the code you need.

http://zo-d.com/blog/archives/progr...oft-project-resource-usage-data-in-excel.html

-Jack Dahlgren