|
发表于 2016-5-8 14:23
|
显示全部楼层
本楼为最佳答案
'备份
Private Sub CommandButton1_Click()
Dim p As String, f As String
ThisWorkbook.Save
p = "D:\DATA\"
f = ThisWorkbook.FullName
With CreateObject("Scripting.FileSystemObject")
If .FolderExists(p) = False Then .CreateFolder p
.CopyFile f, p
Call rename(p, .GetBaseName(f), .GetExtensionName(f))
End With
End Sub
'更名
Sub rename(p, f, e)
Dim OldName, NewName
OldName = p & f & "." & e
NewName = p & f & Format(Now, "-yyyymmhh-hhmmss.") & e
Name OldName As NewName ' 更改文件名。
End Sub
工作记录4.rar
(15.45 KB, 下载次数: 5)
|
|