View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to code macro to close Excel Application?

Thank everyone very much for suggestions
If I close Excel application, will it save this file first before closing?
Does anyone have any suggestions how to edit the code to save the file first
before closing the application?
Thank everyone very much for any suggestions
Eric

"Jacob Skaria" wrote:

Hi Eric

Try

Application.DisplayAlerts = False
Application.Quit

--
Jacob


"Eric" wrote:

Does anyone have any suggestions how to code macro to close Excel Application?
I have a macro coding, and would like to add code to close Excel Application
at the end of macro.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric