|
- Sub 手动双面打印()
- Dim Pages As Long, i%
- On Error GoTo Print_Err
- Pages = ExecuteExcel4Macro("Get.Document(50)") '统计总页数
- Select Case Pages
- Case 0
- MsgBox "Microsoft Excel 未发现任何可以打印的内容", 0 + 48
- Case 1 '如果只有1页,打印然后退出
- ActiveSheet.PrintOut
- Err.Number = 1004
- Case Is > 1
- For i = 1 To Pages Step 2 '打印奇数页
- ActiveSheet.PrintOut From:=i, To:=i
- Next
- If MsgBox("请将出纸器中已打印好一面的纸取出并将其放回到送纸器中," _
- & "然后按下""确定"",继续打印", 1 + 48) = 1 Then
- For i = 2 To Pages Step 2 '打印偶数页
- ActiveSheet.PrintOut From:=i, To:=i
- Next
- End If
- End Select
- Print_Exit:
- Exit Sub
- Print_Err:
- MsgBox "在打印时发生错误,请检查你的打印机设置", 0 + 48
- Resume Print_Exit
- End Sub
复制代码
|
|