For some reason, the SaveAs method within the Workbook_BeforeSave does not save the file appropriately if it is being called from the Workbook_BeforeClose Event.
However, it works fine if you were to just attempt to Save As normally.
Please assist.
TestingWow.xlsm
Bookmarks