Excel crashes when closing a active workbook

[Jambai]

Hello,

I have an excel file with macros in it. These macros are running fine on excel 2002/2003. We are upgrading MS Office in our company to Office 2010.

When I run the macros on Excel 2010, excel crashes at

ActiveWorkbook.Close savechanges:=True

The workbook is saved but it quits excel application. so, If I have other excel files open, all the files are closed.

If I split the above line as

ActiveWorkbook.SaveAs MasterBook.Path & "\Test.xlsm", FileFormat:=52
ActiveWorkbook.Close

It saves the workbook and crashes again at Activeworkbook.close

Can anyone please help me why this is happening?

Thanks in advance
PK

 

[D Weese]

I am having the same issue. Anyone have a solution? If I comment out the close line, everything works fine...just have a boat load of files to close afterwards.

 

[D Weese]

Found a solution that is working for me now:

Workbooks(wrkBookName).Save 'include only if you need to save the file first
Workbooks(wrkBookName).Saved = True
Workbooks(wrkBookName).Close