Analyze Timescaled Data in Excel tool

[tnguye40]

Hi,
Do you know how to make the "Analyze Timescaled Data in Excel" add-in
to export other fields (i.e. ID, Charge Number, etc.) to Excel?

Presently, the "Analyze Timescaled Data in Excel" add-in only exports
the task name and the timescaled data.

Thanks,
Tri

 

[Dave]

You can't make that particular tool do it as it only exports those
fields that it offers you from the wizard.

If you save your file as an Excel document, you can create a map and
export pretty much anything you want to.

It isn't clear from your post what it is you want to achieve by
exporting to Excel.

Dave

 

[Tri]

I want to export the cost timescaled data to an Excel file using the
tool. Then I need to group all the result tasks by charge numbers. The
issue is the tool does not export any other field other than the Name
field.

I am trying to modify the "Analyze Timescaled Data in Excel" macro. But
unable to import five forms included with the macro, which Microsoft
provides.

Thanks,

 

[John]

I want to export the cost timescaled data to an Excel file using the
tool. Then I need to group all the result tasks by charge numbers. The
issue is the tool does not export any other field other than the Name
field.

I am trying to modify the "Analyze Timescaled Data in Excel" macro. But
unable to import five forms included with the macro, which Microsoft
provides.

Thanks,
Tri

Tri,
With Project 98, the userforms and VBA code behind the Analyze
Timescaled data in Excel macro was directly available under
Tools/Macros/Macro. However beginning with Project 2000 the tool was
converted to an add-in utility and I believe the code is now done in VB
(i.e. not VBA). So if you don't have a stand alone VB application, you
probably can't get all the info you need to modify the code. At least
that's how I remember it.

There are a couple of options. As Dave suggested you can export the
static data using an export map. This will cover any non-timescaled
fields you need. Then use the "analyze ..." utility for the timescaled
data and combine the information in Excel to produce what you need.

However, since you indicated you want to modify the existing utility
code, I assume you have familiarity with Project VBA. In that case, (and
the approach I would use), write your own VBA macro to export whatever
data you need. If you need some help with the code, we can answer
questions, although you should probably post on our
microsoft.public.project.developer newsgroup. Or, one of our MVPs, Rod
Gill has just recently written an excellent book on Project VBA. For
more details see: http://www.projectvbabook.com

John
Project MVP