How to code macro to close Excel Application?
On 8 ene, 06:09, Eric wrote:
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
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
|