Analyze Timescaled Data in Excel

[Greg]

Hi,

I am currently putting together macros in Project 2003. I
would like to write a macro to access the 'Analyze
Timescale Data in Excel' functionality and set the data
export fields to what I need. I use this functionality
many times a week and it is very time consuming going
through the wizard and setting up the data to be extract.
Is there a macro that I can call to perform this task??

Thanks. Greg

 

[Rod Gill]

Hi,

Try the www.mvps.org/project/vba/ site. There is a demo macro that does
timescaled data there.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[JackD]

You can download the code for the addin from MSDN.microsoft.com and then
modify it (hard code) the fields the way you like.
Other than that, the addin can not be scripted as far as I can tell.

-Jack

 

[Guest]

Jack,

Thanks for the response.

I have gone to MSDN.microsoft.com but could not find the
addin code to analyze data.

I have looked in downloads and code centre. Am I looking
in the wrong place??

Thanks again & regards. Greg

 

[Sarah]

Apparently all downloads for the 2000 version have been removed.

Sarah

 

[JackD]

That is bad news.
I have a copy somewhere on my HD
Send me an email if you are desperate to have it.
I'll see if I can figure out if it is OK to post it.

-Jack

 

[Greg B]

Jack,

I would greatly appreciate if you could send me the code.

Email to (e-mail address removed)

Thanks again. Greg

 

[JackD]

Actually someone did find it:

http://www.microsoft.com/downloads/...69-ED3E-4DAB-8EFD-4BAE1B918EC3&displaylang=en

So, you can still get the code.
The code which handles the export is in form 5.
You can open the file with a text editor and copy into the project visual
basic editor.
Then you need to edit so that the variables referenced from the other forms
work.

-Jack