Hello
I use this code to backup my woorkbooks and it is working great, now my question
I have a WB thats name are EMV INTERN REV and date of revision
I use this as a template and change date on it when i have done some changes
How can i rewrite this code so it will only create backup when the WB are named EMV INTERN REV and some date, if i change the whole name it will not be created a backup
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim backupfolder As String ThisWorkbook.Saved = True backupfolder = "O:\EMV KS-System NS-EN 9001\EMV Arbeidsb?ker\EMV Backup arbeidsb?ker\" ThisWorkbook.SaveCopyAs Filename:=backupfolder & ThisWorkbook.Name End Sub
Bookmarks