Forum Discussion
Jorge5445
Aug 10, 2023Copper Contributor
MS Word backup
Hi all
I use this Excel VBA snippet in order to backup an Excel file:
Private Sub Workbook_Open()
mfile = Split(ThisWorkbook.Name, ".")
backupFile = ThisWorkbook.Path & "\" & mfile(0) & "-respaldo-" & Format(Now, "dd-mm-yyyy") & "." & mfile(1)
If Day(Now) = 1 Or Day(Now) = 10 Or Day(Now) = 20 Then
ThisWorkbook.SaveCopyAs backupFile
End If
End Sub
I'm looking for something similar to backup my Word document/file.
Thanks in advance for your help
ColdGeorge
No RepliesBe the first to reply