L
Legacy 260385
Guest
Is it possible to create a macro that automatically saves a backup of the excel document in another desired location?
I have this formula:
But that just keeps on making multiple copies of the file rather than overwriting the backup in the D:\ location.
Also, that particular macro requires me to have to click on a button in order for it to work but I would prefer that it happens automatically when the original file is saved.
Thank You
I have this formula:
Sub backupbutton()
Dim fname
fname = "D:\" & Format(Now, "dd mmm yy hh mm") & ".xlsm"
ThisWorkbook.SaveAs Filename:=fname
End Sub
But that just keeps on making multiple copies of the file rather than overwriting the backup in the D:\ location.
Also, that particular macro requires me to have to click on a button in order for it to work but I would prefer that it happens automatically when the original file is saved.
Thank You
