|
楼主 |
发表于 2024-6-5 12:57
|
显示全部楼层
Sub 备份()
Dim sh As Worksheet, m&, rq
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each sh In Worksheets
If sh.Name Like "周[一二三四五]" Or sh.Name = "周汇总" Then
m = m + 1
If m = 1 Then sh.Select Else sh.Select False
End If
Next
rq = Sheets("周汇总").Range("A24") & Format(Sheets("周一").Range("A24"), "yyyymmdd") & "-" & Format(Sheets("周五").Range("A24"), "yyyymmdd")
ActiveWindow.SelectedSheets.Copy
bf = ThisWorkbook.Path & "\食堂公示备份"
If Len(Dir(bf, vbDirectory)) = 0 Then MkDir bf '建目录
ActiveWorkbook.Close True, bf & "\" & rq & ".xlsx"
Sheets("周汇总").Select
Application.ScreenUpdating = True
Application.DisplayAlerts = True
'MsgBox "备份完毕!"
End Sub
老师,因为需要轮换使用,我在你的后面加了一个call 备份,现在把周一-周五和周汇总都备份了,想不要放假的表,能否帮忙修改一下 |
|