Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Close all workbooks and keep excel running
Is there a way to close all workbooks without exiting excel? I have found
where you can exit excel and it will close all workbooks. I have a scenario where it is desirable to close all open workbooks and keep excel running. Anyone know of a way of doing this without closing each workbook individually? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Close all workbooks and keep excel running
You can use this macro:
Sub Close_All_Open_Workbooks() Dim I For I = 1 To Application.Workbooks.Count Application.Workbooks(I).Close Next End Sub On Jun 25, 8:49*am, Scott Hutslar <Scott wrote: Is there a way to close all workbooks without exiting excel? *I have found where you can exit excel and it will close all workbooks. *I have a scenario where it is desirable to close all open workbooks and keep excel running. * Anyone know of a way of doing this without closing each workbook individually? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Close all workbooks and keep excel running
Thanks for the reply Tim. This is a good way of doing this if we create a
global macro for all users to execute. Is there a way provided by Excel for an end user to do this? I guess I am looking for a Ribbon path for doing this. "Tim879" wrote: You can use this macro: Sub Close_All_Open_Workbooks() Dim I For I = 1 To Application.Workbooks.Count Application.Workbooks(I).Close Next End Sub On Jun 25, 8:49 am, Scott Hutslar <Scott wrote: Is there a way to close all workbooks without exiting excel? I have found where you can exit excel and it will close all workbooks. I have a scenario where it is desirable to close all open workbooks and keep excel running. Anyone know of a way of doing this without closing each workbook individually? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Close all workbooks and keep excel running
Scott,
Does FileClose not work for this purpose? It will close all open Workbooks and leave the Excel application open. -- --Thomas [PBD] Working hard to make working easy. "Scott Hutslar" wrote: Thanks for the reply Tim. This is a good way of doing this if we create a global macro for all users to execute. Is there a way provided by Excel for an end user to do this? I guess I am looking for a Ribbon path for doing this. "Tim879" wrote: You can use this macro: Sub Close_All_Open_Workbooks() Dim I For I = 1 To Application.Workbooks.Count Application.Workbooks(I).Close Next End Sub On Jun 25, 8:49 am, Scott Hutslar <Scott wrote: Is there a way to close all workbooks without exiting excel? I have found where you can exit excel and it will close all workbooks. I have a scenario where it is desirable to close all open workbooks and keep excel running. Anyone know of a way of doing this without closing each workbook individually? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Close all workbooks and keep excel running
Thanks Thomas. Close just closes the current (active) workbook. But your
suggestion prompted me to customize my tool bar and add a "Close All" button. This can be found in the commands "Not in the Ribbon". Thanks everyone for your help! "Thomas [PBD]" wrote: Scott, Does FileClose not work for this purpose? It will close all open Workbooks and leave the Excel application open. -- --Thomas [PBD] Working hard to make working easy. "Scott Hutslar" wrote: Thanks for the reply Tim. This is a good way of doing this if we create a global macro for all users to execute. Is there a way provided by Excel for an end user to do this? I guess I am looking for a Ribbon path for doing this. "Tim879" wrote: You can use this macro: Sub Close_All_Open_Workbooks() Dim I For I = 1 To Application.Workbooks.Count Application.Workbooks(I).Close Next End Sub On Jun 25, 8:49 am, Scott Hutslar <Scott wrote: Is there a way to close all workbooks without exiting excel? I have found where you can exit excel and it will close all workbooks. I have a scenario where it is desirable to close all open workbooks and keep excel running. Anyone know of a way of doing this without closing each workbook individually? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Close all workbooks and keep excel running
In earlier versions CTRL + w closed all workbooks but user is asked about
saving. Gord Dibben MS Excel MVP On Wed, 25 Jun 2008 06:10:01 -0700, Scott Hutslar wrote: Thanks for the reply Tim. This is a good way of doing this if we create a global macro for all users to execute. Is there a way provided by Excel for an end user to do this? I guess I am looking for a Ribbon path for doing this. "Tim879" wrote: You can use this macro: Sub Close_All_Open_Workbooks() Dim I For I = 1 To Application.Workbooks.Count Application.Workbooks(I).Close Next End Sub On Jun 25, 8:49 am, Scott Hutslar <Scott wrote: Is there a way to close all workbooks without exiting excel? I have found where you can exit excel and it will close all workbooks. I have a scenario where it is desirable to close all open workbooks and keep excel running. Anyone know of a way of doing this without closing each workbook individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I close multiple Excel '07 workbooks at the same time? | Excel Discussion (Misc queries) | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
close workbooks without closing excel ? | Excel Discussion (Misc queries) | |||
Is there a way to force Excel to close workbooks independently? | Excel Discussion (Misc queries) | |||
Why does Excel close all workbooks? | Setting up and Configuration of Excel |