ActiveWorkbook.Close in .xlsm

[Jambai]

Hi,

How to 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.

 

[GlennUK]

Does your workbook have a Workbook_Close event, and if so, what code is there?

 

[Jambai]

No, it doesn't have Window_close. Actually it is converted from Excel 2003 to Excel 2010. It is working fine in 2003.

The .Close works fine, but it closes the other excel file also.

Thanks

 

[GlennUK]

I'm no expert on Excel 2010 ( never used it ), and I don't know if there are any known bugs with it, sorry. If it worked in Excel 2003, then it's not likely to be a design problem.