ExcelBanter - Terminate Excel with a Macro???

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Terminate Excel with a Macro??? (https://www.excelbanter.com/excel-programming/347252-terminate-excel-macro.html)

Ken Soenen

Terminate Excel with a Macro???

Can Excel be closed automatically after running a Macro, or from the Macro?

bpeltzer

Terminate Excel with a Macro???

Sure, from the macro: application.quit (Be sure to save your file before
testing this step!).

"Ken Soenen" wrote:

Can Excel be closed automatically after running a Macro, or from the Macro?

Ken Soenen

Terminate Excel with a Macro???

I must have looked in the Application method list 500 times. I don't know
why I couldn't find QUIT. But, it's there!!!
Thank you

"bpeltzer" wrote in message
...
Sure, from the macro: application.quit (Be sure to save your file before
testing this step!).

"Ken Soenen" wrote:

Can Excel be closed automatically after running a Macro, or from the
Macro?

All times are GMT +1. The time now is 03:41 PM.