Application.Quit not funtioning in Sub Auto_open

B

BenR

I am trying to update some macros developed for OfficeXP PowerPoint to Office
2007. I cannot get the Application.Quit command to function as needed. The
..Quit function works fine in typical macro form and in the VBA compiler,
however I need the code to execute upon startup of the file in the
Auto_open() sub. The presentation containing the macro is saved as an add in
(.ppa) and the macro run by calling the .ppa file. The code sample below
demonstrates my problem.

Sub Auto_open()
PowerPoint.Application.Quit
End Sub

I just need a way to shutdown PowerPoint when the macro is done.
Thanks in advance.
 
B

BenR

Thanks Steve, what you said was what I was suspecting; chalk it up to another
"used to work" bit of code. The external app is my last resort.
Thanks again,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top