Close Workbook and Excel

[DarbyBrown]

I have a macro that is supposed to Close the open Workbook, and shutdown Excel. It closes the Workbook OK, but does not shutdown Excel.

The code is below, what is wrong?

I am running Excel 2010, on Windows 10 Pro.

Code for Savit

Sub Savit()
'
' Savit Macro
' Saves and closes the workbook
'
' Keyboard Shortcut: Ctrl+s
'
Application.DisplayAlerts = False
With ThisWorkbook
.Save
.Close
End With
Application.DisplayAlerts = True
Application.Quit
End Sub

 

[JLGWhiz]

Are you getting any messages or alerts?

 

[Joe4]

Welcome to the Board!

If you close the workbook, it cannot get to the lines of code after that!
So just remove the:

.Close

line, and it will work the way you want.

 

[DarbyBrown]

Are you getting any messages or alerts?

No, it just closes the Workbook and Excel stays open. No message, no alert, nothing just a new Excel Worksheet.

 

[Joe4]

See my reply above.
By closing it before quitting, you are essentially terminating the code running at that point (if the workbook has been closed, it cannot continue to run any code posted below that line!).
Quitting Excel will also close the workbook, so you do not need an explicit command for that.

 

[DarbyBrown]

Welcome to the Board!

If you close the workbook, it cannot get to the lines of code after that!
So just remove the:

.Close

line, and it will work the way you want.

Thank You, how simple. Looking me right in the face and still couldn't see it.