ExcelBanter - How to close All Workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to close All Workbooks (https://www.excelbanter.com/excel-programming/403333-how-close-all-workbooks.html)

Mervyn Thomas

How to close All Workbooks

Since installing excel 2007 my personal file.xls remains open when the
active workbook is closed. This also is the case when programmatically
"Worknooks.close" is used to shut down hopefully everything. Anyone
explain what is happening

Barb Reinhardt

How to close All Workbooks

Try Application.Quit
--
HTH,
Barb Reinhardt

"Mervyn Thomas" wrote:

Since installing excel 2007 my personal file.xls remains open when the
active workbook is closed. This also is the case when programmatically
"Worknooks.close" is used to shut down hopefully everything. Anyone
explain what is happening

All times are GMT +1. The time now is 06:11 AM.