|
|
#1
03-10-2014, 09:43 AM
|
|||
|
|||
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 
|
| 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 |
Windows XP 
Office 2007
Threaded Mode