使用VBA可能比较快! sub Sheet2workbook() Dim Sht As Worksheet, Wp As String, Wkb As Workbook Set Wkb = ActiveWorkbook Wp = Wkb.Path For Each Sht In Wkb.Worksheets Sht.Select Sht.Copy ActiveWorkbook.SaveAs Filename:=Wp & "\" & Sht.Name & ".xlsx", FileFormat _ :=xlOpenXMLWorkbook, CreateBackup:=False ActiveWorkbook.Close 0 Next End Sub