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.
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.