|
发表于 2015-7-23 11:00
|
显示全部楼层
本楼为最佳答案
得另建一个工作表,用于操作。代码如下:- Sub tt()
- Dim wb As Workbook
- Set wb = Workbooks.Open(ThisWorkbook.Path & "\顾客信息.xls")
- Application.DisplayAlerts = False
- Application.ScreenUpdating = False
- arr = wb.Sheets(1).[a1].CurrentRegion
- For i = 2 To UBound(arr)
- If i = 2 Then wb.Worksheets(1).Delete
- wb.SaveAs ThisWorkbook.Path & "" & arr(i, 1) & ".xls"
- With ActiveWorkbook.Sheets(1)
- .[c4] = arr(i, 1)
- .[g4] = arr(i, 2)
- .[c5] = arr(i, 3)
- .[g5] = arr(i, 4)
- .[c6] = arr(i, 5)
- .[g6] = arr(i, 6)
- .[c13].Resize(1, 4) = Array(arr(i, 7), arr(i, 8), arr(i, 9), arr(i, 10))
- End With
- ActiveWorkbook.Save
- Set wb = ActiveWorkbook
- Next
- wb.Close
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|