I have a report that i automated by the task scheduler and for some time i was ok with it staying open once it processed as i was already in other excel files working, so wasn't a big deal, last week i added the following to the processing and having some weird side effects.

This code works on saving and closing the file, BUT it leaves the excel shell open, meaning that the excel application is open, but no workbook is open.

' CLOSE MAIN WORKBOOK
Public Sub SaveAndClose()
    ActiveWorkbook.Close SaveChanges:=True
End Sub
All i want to do is close that instance of excel that was just opened and processed.