|
发表于 2016-5-18 17:10
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- mypath = ThisWorkbook.Path & ""
- Set sht = ThisWorkbook.Sheets(1)
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Application.SheetsInNewWorkbook = 1
- For i = 3 To Range("a65536").End(xlUp).Row
- With Workbooks.Add
- sht.Cells(1, 1).Resize(2, 9).Copy .Sheets(1).[a1]
- sht.Cells(1, "l").Resize(2, 6).Copy .Sheets(1).Cells(1, 10)
- sht.Cells(i, 1).Resize(1, 9).Copy .Sheets(1).[a3]
- sht.Cells(i, "l").Resize(1, 6).Copy .Sheets(1).Cells(3, 10)
- .SaveAs Filename:=mypath & sht.Cells(i, 1) & ".xls"
- .Close 0
- End With
- Next
- Application.SheetsInNewWorkbook = 3
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|