| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Close Files - getting past message
i have written a macro for Excel 2003 to close a group of files. I'm not
trying to save any data just close the files. The files are fairly large and i get message Excel Cannot complete this taks with available resources. I press OK and the files close. I would like to have the macro handle this for me. The message only comes up on two of the files. sub Windows("abc.xls").Activate ActiveWindow.Close Windows("dfg.xls").Activate ActiveWindow.Close Windows("ttt.xls").Activate ActiveWindow.Close close sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why excel close all files when I just want to close one files | Excel Discussion (Misc queries) | |||
| Macro to save & close all opened files | Excel Discussion (Misc queries) | |||
| I want alert message when i close xl window if cells in are blank | Excel Discussion (Misc queries) | |||
| When shutting down my computer, message says Excel can't close. | Excel Discussion (Misc queries) | |||
| Warning message on file close | Excel Worksheet Functions | |||
Threaded Mode
