How to close All Workbooks

's Computer Specifications

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

's Computer Specifications

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
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Close almost all workbooks	ChrisP	Microsoft Excel Programming	2	7th Aug 2008 04:36 PM
Workbooks.Close	andim	Microsoft Excel Programming	5	20th Jun 2008 06:18 PM
workbooks close before	OlieH	Microsoft Excel Programming	1	6th Apr 2008 08:40 AM
why do all excel worksheets/workbooks close when I close one?	=?Utf-8?B?UGVubnk=?=	Microsoft Excel Misc	1	29th Nov 2006 03:49 AM
close all other workbooks	=?Utf-8?B?Um9i?=	Microsoft Excel Programming	5	5th Feb 2006 08:44 PM