Sub 日报表格式生成()
Sheets("日报表模板").Visible = True
Dim sh As Worksheet
Sheets("日报表模板").Copy after:=Sheets(Sheets.Count)
Set sh = ActiveSheet
sh.Name = Sheets.Count - 2 & "日报表"
Sheets("日报表模板").Visible = False
End Sub
Sub 另存报表()
Dim wb As Workbook
Dim x As Integer
For x = 1 To (Sheets.Count - 2)
Sheets(x & "日报表").Copy
Set wb = ActiveWorkbook
wb.SaveAs ThisWorkbook.Path & "/" & x & "日报表.xlsx"
wb.Close True
Next
End Sub