Closing down all open files within Excel

Matt · Apr 9th, 2002, 08:37 AM

Is there a line of code that will close all files open at the present time in excel rather than writing code to close each seperate workbook?

thanks

Matt

codger · Apr 9th, 2002, 08:44 AM

In Excel, holding down the shift key when selecting 'File' from the menu produces a 'Close All' option.

In code, you can do,

Workbooks.Close

Al Chara · Apr 9th, 2002, 08:47 AM

To add onto codger's code, try application.displayalerts=false before workbooks.close. This will turn off the save box.

Matt · Apr 9th, 2002, 08:49 AM

Thanks Codger, I was trying to specify workbooks("*.*").close and hence failed dismally. Interesting holding the shift key down and then going to the file menu - haven't seen that before! Any other interesting variations that add buttons to the standard menus?

codger · Apr 9th, 2002, 08:56 AM

Open experimentation has yielded only shift+edit for copy and paste picture. That's useful for capturing screenshots and passing them around in spreadsheets (like from IT challenged users in an email).

One use for the close all is the ability to save hidden workbooks; elsewise you (more or less) have to exit before you're given the chance to save them.

Apr 9th, 2002, 08:47 AM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	To add onto codger's code, try application.displayalerts=false before workbooks.close. This will turn off the save box. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 08:37 AM	#1
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	Is there a line of code that will close all files open at the present time in excel rather than writing code to close each seperate workbook? thanks Matt

Apr 9th, 2002, 08:44 AM	#2
codger New Member Join Date: Apr 2002 Posts: 23	In Excel, holding down the shift key when selecting 'File' from the menu produces a 'Close All' option. In code, you can do, Workbooks.Close

Apr 9th, 2002, 08:49 AM	#4
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	Thanks Codger, I was trying to specify workbooks(".").close and hence failed dismally. Interesting holding the shift key down and then going to the file menu - haven't seen that before! Any other interesting variations that add buttons to the standard menus?

Apr 9th, 2002, 08:56 AM	#5
codger New Member Join Date: Apr 2002 Posts: 23	Open experimentation has yielded only shift+edit for copy and paste picture. That's useful for capturing screenshots and passing them around in spreadsheets (like from IT challenged users in an email). One use for the close all is the ability to save hidden workbooks; elsewise you (more or less) have to exit before you're given the chance to save them.