Sub test()
Dim arr, wk As Workbook, wkpath$, k%, i%
wkpath = ThisWorkbook.Path & "/"
arr = Range("a1:e" & Cells(Rows.Count, 1).End(3).Row)
Application.ScreenUpdating = False
For k = 2 To UBound(arr)
ThisWorkbook.Activate
Sheet2.Activate
For i = 1 To UBound(arr, 2)
Sheet1.Cells(4, i) = arr(k, i)
Next i
ThisWorkbook.Sheets("Sheet1").Copy
ActiveWorkbook.SaveAs wkpath & Sheet1.Cells(4, 1)
ActiveWindow.Close
Next k
Sheet1.Rows(4) = ""
Application.ScreenUpdating = True
MsgBox "拆分工作薄成功,共" & k - 2 & "个工作薄,存放在" & wkpath & "目录下"
End Sub