|
发表于 2014-7-10 09:05
|
显示全部楼层
本楼为最佳答案
如果不需要按客户生成工作表,而是直接打印,则改为:- Sub test()
- Dim arr, i%
- Application.DisplayAlerts = False
- arr = Sheets("函证信息").Range("a1").CurrentRegion.Value
- For i = 2 To UBound(arr)
- Worksheets("企业询证函模板 ").Copy After:=Worksheets(Worksheets.Count)
- With Worksheets(Worksheets.Count)
- '.Name = arr(i, 2)
- .Range("h3") = "编号:" & arr(i, 1)
- .Range("a5") = arr(i, 2)
- .Range("c12") = arr(i, 3)
- .PrintOut 1, 1
- .Delete
- End With
- Next
- Application.DisplayAlerts = True
- End Sub
复制代码 (代码设定只打印第一页) |
|