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

[DocAElstein]

chill Doc Sir sorry for the same sir

.. Is no problem Chill is good and healthy. - I know it is difficult for you to communicate….


But the same problem again . I think you are unable to explain

This is question :
vba code macro will be placed in a sample1.xlsm
and there are excel files which are opened (it can be 2 or 3 or more also files are opened along with sample1.xlsm)
i have to close all that opened file by vba and keep only sample1.xlsm opened bcoz it contains vba code
(any type of excel file it can be,i request sir only sample1.xlsm file will be opened and any other file opened then it should be close )

This is correct answer to question: http://www.excelfox.com/forum/showth...ll=1#post12537


Answer is correct to question.



If macro http://www.excelfox.com/forum/showth...ll=1#post12537 is wrong for you , then you have asked the wrong question



Try again to explain what you want

[fixer]

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]

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.