Hi,

How do I close xlsm file through VBA code? When I use this code,

ActiveWorkbook.Close savechanges:=true
'or
ThisWorkbook.close savechanges:=true
'or
Workbooks("filename.xlsm").close savechanges:=true
the other excel files also being closed automatically.

The xlsm was converted from Excel 2003. It is working fine in Excel 2003

Any help in this regar is highly appreciated.