Has anyone experienced an Excel VBA ActiveWorkbook.SaveAs which does NOT save and does NOT report an error ?
Posted on 2014-10-16
I have an ActiveWorkbook.SaveAs in Excel 2013 in a subroutine which is called by the SaveAndClose routine called in the following way:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.EnableEvents = False
Application.EnableEvents = True
The ActiveWorkbook.SaveAs fllows a fileSaveName = Application.GetSaveAsFilename(InitialName, "Excel Files (*.xlsm), *.xlsm") which works perfectly well
The file name is completely correct, but NOTHING happens on the SaveAs. No save, no error, it just continues to the next statement.
Any reason why it would do that ?
Thanks for help