Export Resource Usage info into Excel

[Wellie]

I've programmed in Excel using VBA and now I have a need to program in MS Project s.t. I can export the Resource Usage info into Excel. Hence, I can import the weekly planned/actual hours of each resource into my Finance spreadsheet to calculate the billabble utilization

Can someone please tell me where do I start s.t. I can start to learn programming in MSP to export each resource's weekly planned/actual hours from the Resouce Usage view into Excel spreadsheet with the same format

If there is a better method not requiring VBA program will even be better

Any assistance will greatly be appreciated. Thanks in advance

 

[John]

Wellie,
The easiest approach is to use the "Analyze timescaled data in Excel"
add-in which is available on the "Analysis" toolbar in Project. You can
experiment with different export formats by running the add-in from the
Gantt view, Resource Usage view or Task Usage view.

If the add-in doesn't give quite what you need or you want to customize
the formatting, a custom export VBA macro is your best bet. As far as
learning VBA for Project, there are a couple of free tutorials from
Microsoft. The first can be found on the MVP webpage at:
http://www.mvps.org/project/links.htm
Go to the bottom of the page and look for "Project 98 Visual Basic
Environment Training Materials". Even though it says Project 98, it is
equally applicable to later versions of Project. A download for Project
2002 VBA is available at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;325846
The basic method you want to use is the TimescaleData Method for
exporting any time related data.

Hope this helps.
John

 

[JackD]

In addition the source code for the Analyze timescaled data add-in is
available for download. Here is the version for Proj 2000. There is one for
2002 also.
http://www.microsoft.com/downloads/...69-ED3E-4DAB-8EFD-4BAE1B918EC3&displaylang=en
You can modify the source code to do what you like.

Here is how to get it from the database:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/pdr/PDR_Timephased_Data_3337.asp

-Jack