I run excel 2016 on a server and im trying to autorun a macro when the save button is clicked on the workbook I have open or if easier run it when workbook closed.
I need it to save the workbook thats open as normal to location it is at and also run the following macro in the background so people dont have to save twice.
ActiveWorkbook.SaveAs Filename:= _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
What im also trying to do is when it saves it to the sharepoint there will already be a file with the same name in it and so I need it overwritten with new file it saving,.
I have had a look at doing it via autosave into one drive but this dont work.