Save file, close and quit application

[sharky12345]

Hi,

I'm using this to save a file before closing and quitting Excel;

Application.Quit
ActiveWorkbook.Close SaveChanges:=True

Is there a way I can close only that instance of Excel and if there are other workbooks open then leave them as such?

I use the .Quit because if this is the only instance and I don't use it then it leaves an instance of Excel running so I need to make sure that doesn't happen too.

 

[bugmonsta]

Have a look at this previous post where sericom answered their own question

http://www.mrexcel.com/forum/excel-questions/264146-visual-basic-applications-close-excel-if-no-other-workbooks-open.html