Analyze Timescaled Data Wizard

[Jim Stoaks]

The Wizard allows you to pick from a list of fields to export. Is there a
way to add fields to the list of available fields or is there another way to
export timescaled data that would include different fields?

 

[John]

The Wizard allows you to pick from a list of fields to export. Is there a
way to add fields to the list of available fields or is there another way to
export timescaled data that would include different fields?

Jim,
Possibly, and yes. If you can get ahold of the code for the utility,
(the underlying code was included with Project 98, thereafter it was an
add-in or utility and the code had to be downloaded from the Microsoft
website and it had to be run from a separate VB application), you could
modify it to add whatever fields you want. This requires of course that
you have a good understanding of VBA and are willing to slug through
some rather complex and intertwined code.

In my opinion, it is much easier to write your own custom VBA code to
export timescaled (or any other data). It does however again require
knowledge of (or a willingness to learn) VBA, or someone to write the
code for you.

If VBA is not your thing there is another method although not very
efficient. You can always set up a timescaled view (e.g. Resource or
Task Usage) with the fields you want and then do a copy and paste to
Excel. It tedious, but it will get you there.

Hope this helps.
John
Project MVP

 

[JackD]

You can not add more without modifying the code.
You can find the source code for the add-in here:
http://www.microsoft.com/downloads/...69-ED3E-4DAB-8EFD-4BAE1B918EC3&displaylang=en
I think the fourth form is the one with the code which actually does the
export. You can modify that and add whatever other fields you want.
You don't really need to recompile it as an add-in. With some minor
modification you can run it as a macro.