View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Open wrkBook (auto_open) programmatically

Macros named Auto_Open do not run when the workbook is opened
programmatically. If you are finding something different, then this is
unexpected behavior. RunAutoOpen is a method provided to run the auto_open
macros after the workbook is opened programmatically.

Any macros in the Workbook_Open event will run regardless of how the
workbook is opened. These can be suppressed with application.EnableEvents =
False before opening in xl2002 and later. In xl2000 and xl97, you have to
run a macro in excel itself to issue this command.

--
Regards,
Tom Ogilvy

"Sean McPoland" wrote in message
...
Hi ya'll

right Office 2003,

I have a workbook with an Auto_Open Macro. I am opening
the Workbook subsequently in Power point VBA.

I have tried using READONLY = true and Editable= (T&F)
however the auto_open macro still executes.

How do I simulate the manual method of Open without
running Auto_Open macro in VBA?

I tried the Workbook.RunAutoOpen but that didn't seem to
work but that only works after the workbook is open
rather than at the Application level.

Your help gratefully received.

regards
Sean