But because there are so many new file formats in Excel 2007-2016, we shouldn't use code like this that does not specify the FileFormat parameter. In Excel 2007-2016, SaveAs requires you to provide both the FileFormat parameter and the correct file extension. For example, in Excel 2007-2016, this will fail if the ActiveWorkbook is not an xlsm file. ActiveWorkbook.SaveAs C: ron.xlsm, fileformat:=52. 52 = xlOpenXMLWorkbookMacroEnabled = xlsm (with macro's in 2007-2016). In Excel for the Mac the values are 1.