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

[DocAElstein]

..... rest all files should be closed there can be 2 or 3 or file can be opened

This is contradiction?????

A file can be closed
A file van be left opened
A file cannot be open and closed – That is nonsense.


Try to explain again please

Or

Try this

Sub STEP_CloseOnly_Book1_xlsm()
Dim AnyWb As Workbook
    For Each AnyWb In Workbooks
        If AnyWb.Name = "Book1.xlsm" Then
         AnyWb.Close Savechanges = True
        Else
         
        End If
    Next AnyWb
End Sub

Or

Sub Close_Book1_xlsm()
 Workbooks("Book1.xlsm").Close Savechanges = True
End Sub

[fixer]

chill Doc Sir sorry for the same sir

[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.