Sub demo()
Application.DisplayAlerts = False
dummy = ThisWorkbook.Name & ".dummy"
ActiveWorkbook.SaveCopyAs dummy
arr = [a1].CurrentRegion
col = UBound(arr, 2)
For i = 2 To UBound(arr)
Path = ThisWorkbook.Path & "\" & arr(i, 1) & ".xlsx"
Set wb = Workbooks.Open(dummy)
For s = 1 To Sheets.Count
With Sheets(s)
.Range(.Cells(i, 1), .Cells(i, col)).Copy .Range("A2")
.UsedRange.Offset(2).Clear
End With
Next
wb.SaveAs Path, FileFormat:=xlOpenXMLWorkbook
wb.Close
Next
End Sub
祝順心,南無阿彌陀佛!