View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default How to Exit Excel Automatically

JPMS,

In addition to the other responses that you rec'd, you might
want to use:
Application.DisplayAlerts = False
just before the
Application.Quit

This will suppress any prompts to save the workbook
if your macros have made any changes to it.

John

"JMPS" wrote in message
...
I was wondering if there was an easy way to exit Excel automatically once

all the Auto_Open Macros completed.