执行下面的宏:
Sub Macro1()
Dim arr, i As Long, c As Long
Application.ScreenUpdating = False
arr = [a1].CurrentRegion
c = UBound(arr, 2)
For i = 1 To UBound(arr)
Workbooks.Add
ActiveSheet.[a1].Offset(i - 1, 0).Resize(1, c) = Application.Index(arr, i, 0)
ActiveWorkbook.SaveAs ThisWorkbook.Path & "\" & arr(i, 1) & ".xls"
ActiveWindow.Close
Next
Application.ScreenUpdating = True
MsgBox "ok"
End Sub