Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function triggering a macro | Excel Worksheet Functions | |||
Daily Macro Triggering | Excel Discussion (Misc queries) | |||
Excel Macro exporting to MS-Project 2002 | Excel Programming | |||
Triggering Macro Execution | Excel Programming | |||
Triggering an Excel macro on press of SAVE | Excel Programming |