Timescaled data

[Cheryl]

Is there a way to add fields to the timescaled data export?
I need the capability to add the project field as well as
other text fields I have defined.
Thanks,
Cheryl

 

[John]

Cheryl,
Yes and no. You can obtain the VBA code for the timescaled data add-in
by going to:
http://microsoft.com/downloads/details.aspx?FamilyId=A7E06469-ED3E-4DAB-8
EFD-4BAE1B918EC3&displaylang=en
However, unless you have some experience with VBA you may find the code
rather daunting.

The only data the add-in exports is timescaled data. Most fields,
including the Project field and spare text fields, are not timescaled.
In other words, they are single valued. And although single valued
fields can be included in the export, doing so will require a fair
amount of re-coding. You might be better off to write your own custom
macro. Then you can export any fields you need. Or as an alternative,
export the single valued fields using an export map and then use the
add-in to export the timescaled data. You will have to do some combining
and re-formatting in Excel, but at least you can get there.

Hope this helps.
John

 

[Sean]

Cheryl:

If you're using Project 2003, you won't need the add in;
however, as John mentioned export timephased data to
excel will not allow you to export non-timephased
information. All exported timephased data will at least
contain the project name as well as date formatting that
you select. Try experimenting with the view you export
from, as it will result in different formatting. For
example, exporting from the Gantt view will show task
names, whereas exporting from the resource usage view
will show resource names.

Hope this helps!