Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close other open excel files
HI,
I'd like my wb on opening to close all other excel files that are open (prompting them to save first). I'd also like to prevent the user opening any other excel files whilst my wb is open. Is this possible (and is it a stupid thing to try and do?) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close other open excel files
Easy
for each wbk in workbooks if wbk.name < ThisWorkbook.name then workbooks(wbk.name).close end if next wbk "anon" wrote: HI, I'd like my wb on opening to close all other excel files that are open (prompting them to save first). I'd also like to prevent the user opening any other excel files whilst my wb is open. Is this possible (and is it a stupid thing to try and do?) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close other open excel files
test
"Greg H." wrote in message ... How can i modify this to prevent thisworkbook.name and another excel file not to close? I need the files "Daily Reports.xls" and "NPP_*" to stay open. Thanks "Joel" wrote: Easy for each wbk in workbooks if wbk.name < ThisWorkbook.name then workbooks(wbk.name).close end if next wbk "anon" wrote: HI, I'd like my wb on opening to close all other excel files that are open (prompting them to save first). I'd also like to prevent the user opening any other excel files whilst my wb is open. Is this possible (and is it a stupid thing to try and do?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open and close files | Excel Worksheet Functions | |||
How to open a list of excel files and get update, then close it? | Excel Discussion (Misc queries) | |||
Open Save & Close All Files in Dir | Excel Programming | |||
Open all linked files and close them. | Excel Programming |