Anaylze TSD in Excel wizard automation

[Conrad Santiago]

Hello Fellow Schedulers
Is there a way to automate the use of the "Analyze Timescaled Data in Excel" wizard?
I use Excel charts to graph backlog work. I run the "Analyze Timescaled Data in Excel" wizard to output worksheets for 10 different groups of resources.
In Project, I run a filter for each group, select all, then run the wizard, so I'm inputting the same entries to the wizard.
I'd like to be able to automate that
Is there a VB code that emulates the wizard
Is there a way to use VB to input the same entries into the wizard
Any other ideas

Thanks
--Conrad Santiag

 

[William Raymond]

Hi Conrad,

I think you are on the right track to writing VBA code. Unfortunately, you
cannot automatically record a macro that performs all these steps.

You can get the timscaled data using VBA code and this can be filtered as
well. Here are some VBA commands to point you in the right direction.
Since I do not have a piece of code to share with you right now, I would
recommend you take a look at these methods, then post follow-up questions on
the microsoft.public.project.developer newsgroup.

SelectTimescaleRange
TimeScaleData

If you decide to store your projects in a database (and you do not need
Project Server to do this), you can look up msdn.microsoft.com and read up
on how to get the timescaled data directly out of the database with queries.

-Bill

--
Bill Raymond
projectnation at hotmail dot com

Hello Fellow Schedulers,
Is there a way to automate the use of the "Analyze Timescaled Data in Excel" wizard?
I use Excel charts to graph backlog work. I run the "Analyze Timescaled

Data in Excel" wizard to output worksheets for 10 different groups of
resources.

In Project, I run a filter for each group, select all, then run the

wizard, so I'm inputting the same entries to the wizard.

 

[John]

Conrad,
I tried a little experiment of recording a macro using the "Analyze ..."
add-in but it didn't work. Personally, I think you are better off with a
custom VBA macro. A macro can export any Project data to Excel and then
automatically format it, all with one button click. If there are some
options to select for various types of export, a userform can be
incorporated into the macro for that purpose (basically your own custom
wizard). I have used this method countless times and it works great.

John