Breaking

Sunday 20 May 2018

VBA Excel VBA - Create a backup of a current workbook

Excel VBA - Create a backup of a current workbook

by on in

Copy & Paste the following code in Excel VBA.
Sub FileBackUp()
ThisWorkbook.SaveCopyAs Filename:=ThisWorkbook.Path & _
"" & Format(Date, "mm-dd-yy") & " " & _
ThisWorkbook.name
End Sub 

Sub FileBackUp()

ThisWorkbook.SaveCopyAs Filename:=ThisWorkbook.Path & _

"" & Format(Date, "mm-dd-yy") & " " & _

ThisWorkbook.name

End Sub
By at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)