Close All Open Excel Files With VBA Open Close File issue unsolved

**fixer** · 03-03-2020, 04:50 PM

i need a macro
i will place the macro in any file and i will run that macro
and when i run that macro all files should be closed if there will be any opened file except the file in which macro is placed

**DocAElstein** · 03-03-2020, 04:56 PM

Originally Posted by fixer

i will place macro in any file and i will run that macro
and when i run that macro all files should be closed if there will be any opened file except the file in which macro is placed

Put this macro http://www.excelfox.com/forum/showth...ll=1#post12537 in any file.
Run the macro
All Excel files will be closed , except the file in which you have put the macro: The file with the macro will stay open. All other Excel files will be closed.