Triggering Excel Macro from MS-Project
 

I have been trying to run an excel macro from a MS-Project VBA macro. I can
activate Excel and bring it to the foreground, but I cannot get the macro to
run.

Any ideqas on how to make this work? I have tried the examples for
word/access/powerpoint but none of the code works.

JEff

Triggering Excel Macro from MS-Project
 

Hi Buster

can you put your excel macro in the Workbook_Open prodecure and use project
to open the excel workbook and then the macro will fire "automatically".

Cheers
JulieD

"Buster" wrote in message
...
I have been trying to run an excel macro from a MS-Project VBA macro. I can
activate Excel and bring it to the foreground, but I cannot get the macro
to
run.

Any ideqas on how to make this work? I have tried the examples for
word/access/powerpoint but none of the code works.

JEff

Triggering Excel Macro from MS-Project
 

Jeff,

Don't have MS-Project to check, but I assume it supports automation.

You should be able to do Application.Run as normal. Can you post your code?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Buster" wrote in message
...
I have been trying to run an excel macro from a MS-Project VBA macro. I
can
activate Excel and bring it to the foreground, but I cannot get the macro
to
run.

Any ideqas on how to make this work? I have tried the examples for
word/access/powerpoint but none of the code works.

JEff