|
'不关闭原来的工作簿,备份副本。
Private Sub CommandButton1_Click()
Dim p$, f$
p = "D:\DATA\"
If Dir(p, vbDirectory) = "" Then MkDir p '不支持多级目录
f = ThisWorkbook.Name
f = VBA.Replace(f, ".", Format(Now, "-yyyy-mm-dd-hh-mm-ss."))
ActiveWorkbook.SaveCopyAs p & f
End Sub
工作记录一5.rar
(13.5 KB, 下载次数: 5)
|
|