ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Office automation problem (https://www.excelbanter.com/excel-programming/358188-office-automation-problem.html)

vba_nerd

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.





All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com