View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vba_nerd vba_nerd is offline
external usenet poster
 
Posts: 1
Default Office automation problem

Hi,

I have problem with the Office automation security settings.

I have code that processes several PowerPoint presentations. I open the each
of the presentations read-only with no window and do some processing on
them.

But whenever a presentation with macros is processed and the macro's prompt
shows, if I choose "Disable macros" the whole processing presentation loop
dies. It's almost like clicking on the End button in IDE.

If I choose "Enable macros" in the presention currently being processed it
works like a charm....

It seems that "Disable macros" also disable my ppa macros....

I have tried shifting the automation security with no success. Using Office
2003 SP2. I know this isn't a specific Excel problem but maybe you have an
answer this as well.

Thanks in advance.