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