Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA-How to close all open workbooks except one specific?
I have a macro that will close all open workbooks, works great. Now I
would like to have this macro close all open workbooks except one specific files, KeyWest.xls. The below code works and I imagine a simple IF Then sort of statement might solve my problem but I cannot figure it out. Thanks for any help! Ryan Public Sub CloseAll() Dim WB As Workbook SaveAll For Each WB In Workbooks If Not WB.Name = ThisWorkbook.Name Then WB.Close SaveChanges:=True End If Next WB ThisWorkbook.Close SaveChanges:=True End Sub --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA-How to close all open workbooks except one specific?
Hi Ryan,
It currently closes all workbooks except Thisworkbook (the workbook containing this code). Do you just want to change from This workbook to Key west.xls? If so, be aware that if Thisworkbook is not Key West, you will close ThisWorkbook, at which point the macro cannot run any longer. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "waveracerr " wrote in message ... I have a macro that will close all open workbooks, works great. Now I would like to have this macro close all open workbooks except one specific files, KeyWest.xls. The below code works and I imagine a simple IF Then sort of statement might solve my problem but I cannot figure it out. Thanks for any help! Ryan Public Sub CloseAll() Dim WB As Workbook SaveAll For Each WB In Workbooks If Not WB.Name = ThisWorkbook.Name Then WB.Close SaveChanges:=True End If Next WB ThisWorkbook.Close SaveChanges:=True End Sub --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA-How to close all open workbooks except one specific?
If You've placed this macro in KeyWest.xls, what suggests the line:
If Not WB.Name = ThisWorkbook.Name Then then remove the line: ThisWorkbook.Close SaveChanges:=True otherwise change the first mentioned line to: If Not WB.Name = "KeyWest.xls" Then Tomek "waveracerr " wrote in message ... I have a macro that will close all open workbooks, works great. Now I would like to have this macro close all open workbooks except one specific files, KeyWest.xls. The below code works and I imagine a simple IF Then sort of statement might solve my problem but I cannot figure it out. Thanks for any help! Ryan Public Sub CloseAll() Dim WB As Workbook SaveAll For Each WB In Workbooks If Not WB.Name = ThisWorkbook.Name Then WB.Close SaveChanges:=True End If Next WB ThisWorkbook.Close SaveChanges:=True End Sub --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA-How to close all open workbooks except one specific?
Ah great, I somehow missed the code:
ThisWorkbook.Close SaveChanges:=True Teach me not to just copy and paste.... Thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to close all open workbooks in Excel 2007 | Setting up and Configuration of Excel | |||
Workbooks Close, but window stays open | Excel Discussion (Misc queries) | |||
Open Close workbooks | Excel Discussion (Misc queries) | |||
help with macro to open and close workbooks | Excel Programming | |||
Can I have a loop to open a set of workbooks get some data, close it one a time. | Excel Programming |