B
Barb Reinhardt
I'm trying to save a workbook as a .xlsm in Excel 2007 using code.
I find that this works
ThisWorkbook.SaveAs Filename:=filesavename, _
FileFormat:= _
xlOpenXMLWorkbookMacroEnabled
And this doesn't
ThisWorkbook.SaveAs Filename:=filesavename
The workbook can be saved, but it can never be opened again.
Why?
Barb Reinhardt
I find that this works
ThisWorkbook.SaveAs Filename:=filesavename, _
FileFormat:= _
xlOpenXMLWorkbookMacroEnabled
And this doesn't
ThisWorkbook.SaveAs Filename:=filesavename
The workbook can be saved, but it can never be opened again.
Why?
Barb Reinhardt