Sub Macro1()
On Error Resume Next
Dim i&, zf$
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.SheetsInNewWorkbook = 1
For i = 1 To Sheets.Count
If Sheets(i).Name <> "Menu" Then
zf = Sheets(i).Name & ".xls" '文件名
With Workbooks.Add
For j = 2 To ThisWorkbook.Sheets.Count
ThisWorkbook.Sheets(j).Copy after:=.Sheets(.Sheets.Count)
Next
.Sheets(1).Delete
.SaveAs Filename:=ThisWorkbook.Path & "\" & zf '路径+文件名
End With
Workbooks(zf).Close 1
End If
Next
Application.SheetsInNewWorkbook = 3
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub