Passing data - macro > Analyze timescaled > Excel

[Erkki Piipari]

Hi for the first time !

Perhaps someone could poke me to the right direction. My
requirements are as follows :
1) Record a macro in MSP
- with suitable views, filters (Completed Tasks etc)
2)Start Analyze timephased data in Excel
- What is the best way to call this add-in and pass
arguments , so that it can proceed in the background and
create the excel -graph

Thank's in advance !

Erkki Piipari

 

[Rod Gill]

Hi,

The VB code for the Analyze com addin is available from:
http://www.microsoft.com/downloads/...70-e38e-45d5-91d3-65987f459cac&DisplayLang=en

The only way you can pass options in VBA is to use the SendKeys method, but
this is risky. If someone swaps to another program half way thru the macro,
the remaining keystrokes get sent to the new program, with potentially dire
results!

--
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/

 

[John]

Erkki,
I don't believe it is possible to "call" the "Analyze . . ." add-in from
VBA. However, it isn't all that difficult to create a custom VBA macro
to export the necessary data from Project to Excel and then create
worksheets or graphs. Unless a huge amount of data is involved, a custom
macro will run very quickly. Is there a specific reason you want it to
run in the background?

John

 

[Erkki]

Thanks John !

I also thought that "calling" was not an option. So, I'm
interested in exporting timephased data with VBA. I've
seen that somewhere in the net...

PS Check-out these finnish nature photographs of the year
http://www.co.jyu.fi/luonnonvalokuvaajat/vuodenluontokuvia/
gall2004/kansi.htm The -34C was the winner.

Regards

Erkki

-----Original Message-----

Erkki,
I don't believe it is possible to "call"

the "Analyze . . ." add-in from

 

[JackD]

The source code for the "analyze timescaled data ..." add-in is available
at:
http://www.microsoft.com/downloads/...69-ED3E-4DAB-8EFD-4BAE1B918EC3&displaylang=en

You can take the relevant portions of that code and build from there.

-Jack