|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 ykcbf1100 于 2024-6-14 09:41 编辑
参与一下。。。
- Sub ykcbf() '//2024.6.14
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- p = CreateObject("Wscript.Shell").SpecialFolders("Desktop") & ""
- Set ws = ThisWorkbook
- TargetDate = "2024/7/1"
- fn = [{"01","02","03"}]
- If Date >= TargetDate Then
- ws.Sheets(fn).Copy
- Set wb = ActiveWorkbook
- f = p & Split(ws.Name, ".")(0) & "_" & Format(Now, "yyyy-mm-dd HH-MM-SS")
- wb.SaveAs f, 52
- wb.Close
- MsgBox "新工作簿已保存到桌面!"
- End If
- '//以下这部分代码慎用,不然,里面的表会被删得只剩下"空白"一个表,先注销,如你想用可以启用
- '**************************************************************
- ' With ws
- ' .Sheets.Add(After:=.Sheets(.Sheets.Count)).Name = "空白"
- ' For Each sht In .Sheets
- ' If sht.Name <> "空白" Then
- ' sht.Delete
- ' End If
- ' Next
- ' End With
- ' Application.Quit
- '****************************************************************
- Application.ScreenUpdating = True
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|