Terminate Excel with a Macro???

[Ken Soenen]

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

[bpeltzer]

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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>>
>>
>>