|
批量打印编辑;按条件查找sheet1数据表内容到LISTVIEW里,然后将LISTVIEW的数据按照打印模板进行批量打印,模板打印数据信息每页限15条。
老师帮忙给编辑一下,
真是不好意思,在五一劳动节之际还在麻烦老师。
非常感谢老师的每次回复于帮助。
打印按钮的代码。
另外,你的序号了漏了个数。 - Private Sub CommandButton2_Click() '清空
- Dim arrPrint(1 To 15, 1 To 9)
- Dim i As Long, k As Long, l As Long
- Dim arrPos
- arrPos = Array(0, 1, 2, 4, 6, 7, 8)
- With Me.ListView1
- If .ListItems.Count = 0 Then
- MsgBox "列表中无数据可打印"
- Exit Sub
- End If
- Application.ScreenUpdating = False
- 'Application.DisplayAlerts = False
-
- For i = 1 To .ListItems.Count
- l = l + 1
- For k = 1 To 6
- arrPrint(l, arrPos(k)) = .ListItems(i).SubItems(k)
- Next
- If l = 15 Then
- With Worksheets("打印模板")
- .Range("c5").Resize(l, UBound(arrPrint, 2)) = arrPrint
- .PrintOut
- .Range("c5:k19").ClearContents
- Erase arrPrint
- End With
- l = 0
- End If
- Next
- If l > 0 Then
- With Worksheets("打印模板")
- .Range("c5").Resize(l, UBound(arrPrint, 2)) = arrPrint
- .PrintOut
- .Range("c5:k15").ClearContents
- End With
- End If
- End With
- Application.ScreenUpdating = True
- 'Application.DisplayAlerts = true
- MsgBox "打印完成"
- End Sub
复制代码
|
|