Sub 日报表格式生成()
Dim sh As Worksheet
Sheets("日报表模板").Visible = True
Sheets("日报表模板").Copy after:=Sheets(Sheets.Count)
Set sh = ActiveSheet
sh.Name = Sheets.Count-2 & "报表"
End Sub
Sub 另存为工作簿()
Dim wb As Workbook
Sheets.Copy
Set wb = ActiveWorkbook
wb.SaveAs ThisWorkbook.Path & "/第十讲练习.xls"
wb.Close True
End Sub