#1
|
|||
|
|||
Saving macro in Excel 2010
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Saving Macro in Excel 2010
Thanks. I removed the picture from my report and the macro now works okay.
|
Tags |
excel 2010, saving, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
the saveas macro in excel 2010 is not transferring the macros to the new workbook | missmr28 | Excel Programming | 3 | 06-20-2012 05:30 AM |
saving data in excel 2010 from excel 2003 | johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |
Cutting and Pasting and Macro problems in Excel 2010 | enkel | Excel Programming | 3 | 01-02-2012 10:15 PM |
Mail with macro Excel 2010 | santors71 | Excel Programming | 1 | 12-07-2011 06:34 AM |
Saving in Excel 2010 Issues | Terosset | Excel | 7 | 03-09-2011 04:02 PM |