|
- Sub BackupBeforeUpdate()
- Dim BackupPath As String
- MsgBox ThisWorkbook.Name
- BackupPath = ThisWorkbook.Path & "\Backup"
- If Dir(BackupPath, vbDirectory) <> "" Then
- ThisWorkbook.SaveCopyAs Filename:=BackupPath & Replace(ThisWorkbook.Name, ".xls", "(" & Format(Date, "YYYY-mm-dd") & Format(Time, " HH-MM") & ").xls")
- Else
- MkDir BackupPath
- ThisWorkbook.SaveCopyAs Filename:=BackupPath & Replace(ThisWorkbook.Name, ".xls", "(" & Format(Date, "YYYY-mm-dd") & Format(Time, " HH-MM") & ").xls")
- End If
- Application.OnTime Now() + TimeValue("00:05:00"), "BackupBeforeUpdate"
- VBA.DoEvents
- End Sub
复制代码 |
|