|
以下代码已成功实现在excel中奇偶页打印,可是每打一页就复位一下打印第二页,复位的意思就是假如我要打10份,我要点10次当前页打印的那种感觉,要的是点一下,全部打印出来的感觉。意思应该你懂得!每次打印复位的话太耗时了,能否实现这么多页连贯性打印。
Sub 奇偶页打印() '实现奇偶页打印
Dim pageTotal As Integer
Dim jPage As Integer
Dim OK
Worksheets("量化表").Activate
With Sheets("量化表")
pageTotal = Application.ExecuteExcel4Macro("get.document(50)") - 2 '减2代表模板页不要打印
For jPage = pageTotal - IIf(pageTotal Mod 2 = 0, 1, 0) To 1 Step -2
ActiveSheet.PrintOut from:=jPage, To:=jPage
Next
OK = MsgBox("请把纸张装入打印机,打印偶数页", vbOKCancel, "双面打印")
If OK = vbOK Then
For jPage = 2 To pageTotal Step 2
ActiveSheet.PrintOut from:=jPage, To:=jPage
Next
End If
End With
End Sub
补充内容 (2018-2-1 13:40):
如果不懂我说的意思的话,我发出图给你们看,在4楼 |
|