How to code macro to close Excel Application?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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
 
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
Click to expand...

Hi Eric.

One way is application.quit

Regards,


Benito
Barcelona
 
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
 
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
Click to expand...

Hi.

If you want to save all the workbooks opened:

Sub quit()
For Each ws In Workbooks
a = ws.Name
ws.Save
Next
Application.quit
End Sub

If you want to save only the active workbook:

Sub quit()
ActiveWorkbook.Save
Application.quit
End Sub

Regards,

Benito
Barcelona
Spain
 
Back
Top