I have a macro which runs fine in Excel 2007. We have now upgraded to Excel 2010 but the macro won't save.

The code I am using is as follows:-
ActiveWorkbook.SaveAs Filename:="Y:\Reports\Test.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
ActiveWindow.Close

The error message which is returned is
"Errors were detecting while saving, may be able to save the file by removing or repairing some features" which it cannot do either.

Any idea how to get around this issue?
Thanks

That doesn't indicate a fault with the macro, but with the underlying workbook, another aspect of your system and/or that your Excel installation isn't fully updated. See, for example:
http://answers.microsoft.com/en-us/o...c-68b599b31bf5
http://support.microsoft.com/kb/2597034
http://support.microsoft.com/kb/271513

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks. I removed the picture from my report and the macro now works okay.