|
发表于 2015-7-22 11:00
|
显示全部楼层
本楼为最佳答案
本帖最后由 爱疯 于 2020-1-10 15:56 编辑
- Sub tt()
- Application.DisplayAlerts = False
- arr = [a1].CurrentRegion
- For i = 2 To UBound(arr)
- Sheets("顾客信息").Copy
- 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.SaveAs ThisWorkbook.Path & "" & arr(i, 1) & ".xls"
- ActiveWorkbook.Close
- Next
- Application.DisplayAlerts = True
- End Sub
复制代码 |
|