On 8 ene, 06:09, Eric <E...@discussions.microsoft.com> 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
|
Similar Threads
