Save and close entire instance of excel

**rhudgins** · 12-02-2011, 01:30 PM

Can this code be changed to close the entire instance of excel not just the workbook

Please Login or Register  to view this content.

**tigeravatar** · 12-02-2011, 01:37 PM

rhudgins,

Give this a try:

Please Login or Register  to view this content.

**rhudgins** · 12-02-2011, 01:41 PM

That is not working..Not sure why. Only the workbook that the code is in is closing.

**shg** · 12-02-2011, 01:44 PM

Maybe ...

Please Login or Register  to view this content.

That will also save Personal.xls if there is one.

**rhudgins** · 12-02-2011, 01:51 PM

Thank you this works well

**shg** · 12-05-2011, 08:29 PM

You're welcome, glad it helped.

Re: Save and close entire instance of excel