Sub AA()
æ件å = Left(ActiveWorkbook.Name, InStr(ActiveWorkbook.Name, ".") - 1)
åç¼å = Right(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - InStr(ActiveWorkbook.Name, ".") + 1)
a = ActiveWorkbook.Name
On Error Resume Next 'é误继ç»
Application.DisplayAlerts = False 'ç¦æ¢å¼¹åºä¿åæ¿æ¢æ示æ¶æ¯
MkDir "D:\" & "å¤ä»½" '建æ件夹 ThisWorkbook.Path
b = "D:\" & "å¤ä»½\" & æ件å & Now() & åç¼å
ActiveWorkbook.SaveCopyAs a & b
End Sub
温馨提示:内容为网友见解,仅供参考