Sub baocunjichushujv() '保存基础数据 Application.ScreenUpdating = False Dim x As Integer For x = ThisWorkbook.Worksheets.Count To 3 Step -1 Worksheets(x).Copy 这句报错! ActiveWorkbook.Close SaveChanges:=True, Filename:=ThisWorkbook.Path & "\" & Date & ThisWorkbook.Worksheets(x).Name & ".xls" Next Application.ScreenUpdating = True MsgBox "本月报表已备份!"