Venit,
Have you tried the "analyze timescaled data in Excel" add-in found on
the Analysis toolbar? The resulting worksheet in Excel will be different
depending on whether you run it from the Task Usage or Resource Usage
view but it might give you what you need.
However, if you need to have more control over what is exported a custom
VBA macro is the way to go. There are various ways to write the macro
code. If you simply want to export existing Project data fields, first
create an instance of Excel and then run through each element of the
Project data (i.e. task, resource and/or assignment) and write it to
Excel "on the fly". However, if you need to do manipulation on the
Project data, I find it more convenient to read the data, perform the
data manipulation, and then load the result into one or more matricies.
Then open Excel and dump the matricies into one or more Worksheets.
For some reference material, take a look at my response to a post in
this newsgroup titled, "parse current view's tasks and Group headings
with VBA" on 8/8/04. In it I include the code I use for opening an
instance of Excel.
You might also like to take a look at Jack Dahlgren's webpage at:
http://masamiki.com/project/macros.htm
He has several example macros. The macro titled, "Export hierarchy to
Excel" might be particularly useful.
Hope this helps.
John
