夜雨聆风学习资料网

ARTICLE · 1367698

批量打印word文档

批量打印word文档
下面的宏命令实现逐个打印指定文件夹下的所有word文件,打印一个关闭一个。使用方法是打印excel,按ALT+F11,打开vba编辑器,在左侧工程编辑内右击鼠标,选择插入——模块,在右侧粘贴下面代码:,然后按F5运行宏即可。

Option Explicit

'==================================================================

' 批量处理指定文件夹下所有 Word 文档(不递归子文件夹)

' 流程:打开一个 -> 处理 -> 立即关闭 -> 再打开下一个

'       全程只保留一个 Word 实例,内存中始终只有一个文档

' 三种模式(改下面的 MODE 即可切换):

'   MODE = 0  打印到打印机(必须连接"真实"打印机)

'   MODE = 1  直接导出 PDF(不经打印机驱动,不弹框,最稳定)  <-- 当前默认

'   MODE = 2  仅诊断:打开、统计页数、关闭,不产生任何输出

'

' 为什么默认不是 0:

'   本机默认打印机是 Microsoft Print to PDF(端口 PORTPROMPT:)。

'   隐藏的 Word 自动化实例打印到它时会弹出"另存为"对话框且无人应答,

'   Word 挂起 / RPC 断链,于是报 -2147023170(0x800706BE,

'   RPC_S_CALL_FAILED 远程过程调用失败)。接好真实打印机后再把 MODE 设 0。

'

' 运行环境:Excel VBA;后期绑定,无需引用 Word 对象库

'==================================================================

Private Const FIXED_FOLDER   As String = ""   ' 固定文件夹;留空则运行时弹窗选择

Private Const USE_PRINTER    As String = ""   ' MODE=0 时指定真实打印机全名;留空用默认

Private Const PDF_OUT_FOLDER As String = ""   ' MODE=1 时 PDF 输出目录;留空=与源文档同目录

Private Const MODE           As Long = 1      ' 0=打印  1=导出PDF  2=仅诊断

Private Const PAUSE_SEC      As Long = 0      ' MODE=0 打印后额外等待秒数(打印机慢时设 2)

Sub BatchPrintWordDocs()

    Dim folderPath As String, pdfFolder As String

    Dim fileName As String, fullPath As String, msg As String, note As String

    Dim modeName As String, printerName As String

    Dim wdApp As Object, fso As Object, logSheet As Worksheet

    Dim nOK As Long, nFail As Long, r As Long, pages As Long

    Select Case MODE

        Case 0:    modeName = "打印"

        Case 1:    modeName = "导出 PDF"

        Case Else: modeName = "诊断(不打印)"

    End Select

    '--- 1. 取得文件夹 ---

    If Len(FIXED_FOLDER) > 0 Then

        folderPath = FIXED_FOLDER

    Else

        With Application.FileDialog(4)          ' 4 = msoFileDialogFolderPicker

            .Title = "请选择存放 Word 文档的文件夹"

            .AllowMultiSelect = False

            If .Show <> -1 Then Exit Sub        ' 用户点了"取消"

            folderPath = .SelectedItems(1)

        End With

    End If

    Set fso = CreateObject("Scripting.FileSystemObject")

    If Not fso.FolderExists(folderPath) Then

        MsgBox "文件夹不存在:" & vbCrLf & folderPath, vbExclamation

        Set fso = Nothing

        Exit Sub

    End If

    If Right$(folderPath, 1) <> "\" Then folderPath = folderPath & "\"

    '--- 2. PDF 输出目录 ---

    If MODE = 1 Then

        If Len(PDF_OUT_FOLDER) > 0 Then

            pdfFolder = PDF_OUT_FOLDER

            If Right$(pdfFolder, 1) <> "\" Then pdfFolder = pdfFolder & "\"

            If Not fso.FolderExists(pdfFolder) Then

                On Error Resume Next

                fso.CreateFolder Left$(pdfFolder, Len(pdfFolder) - 1)

                On Error GoTo 0

            End If

            If Not fso.FolderExists(pdfFolder) Then

                MsgBox "PDF 输出目录不存在且无法创建:" & vbCrLf & pdfFolder, vbExclamation

                Set fso = Nothing

                Exit Sub

            End If

        Else

            pdfFolder = folderPath

        End If

    End If

    Set fso = Nothing

    '--- 3. 启动 Word(隐藏、免弹窗、禁用文档宏)---

    If Not EnsureWord(wdApp) Then

        MsgBox "无法启动 Word,请确认已安装 Microsoft Word。", vbCritical

        Exit Sub

    End If

    '--- 4. 防呆:打印模式下拦截虚拟打印机 ---

    If MODE = 0 Then

        On Error Resume Next

        printerName = wdApp.ActivePrinter

        On Error GoTo 0

        If Len(printerName) = 0 Then

            MsgBox "读取不到当前打印机,请检查打印机是否安装、Print Spooler 服务是否运行。", vbCritical

            GoTo CleanUp

        End If

        If IsVirtualPrinter(printerName) Then

            MsgBox "当前打印机是【" & printerName & "】,属于虚拟打印机。" & vbCrLf & vbCrLf & _

                   "它打印时会弹出『另存为』对话框,而隐藏的 Word 自动化实例无人点击," & _

                   "Word 因此挂起 / 断链,报 -2147023170(0x800706BE RPC 调用失败)。" & vbCrLf & vbCrLf & _

                   "二选一:" & vbCrLf & _

                   "  ① 把顶部 MODE 改成 1,直接导出 PDF(不需要打印机)" & vbCrLf & _

                   "  ② 接好真实打印机,把 USE_PRINTER 填成它的完整名称", vbCritical

            GoTo CleanUp

        End If

    End If

    '--- 5. 准备打印日志 ---

    Set logSheet = GetLogSheet()

    logSheet.Cells.Clear

    logSheet.Range("A1").Value = "序号"

    logSheet.Range("B1").Value = "文件名"

    logSheet.Range("C1").Value = "页数"

    logSheet.Range("D1").Value = "模式"

    logSheet.Range("E1").Value = "结果"

    logSheet.Columns("A").ColumnWidth = 8

    logSheet.Columns("B").ColumnWidth = 48

    logSheet.Columns("C").ColumnWidth = 8

    logSheet.Columns("D").ColumnWidth = 14

    logSheet.Columns("E").ColumnWidth = 62

    r = 1

    Application.ScreenUpdating = False

    '--- 6. 逐个处理:每次先确认 Word 实例还活着 ---

    fileName = Dir(folderPath & "*")

    Do While Len(fileName) > 0

        If IsWordDoc(fileName) Then

            fullPath = folderPath & fileName

            pages = 0

            note = ""

            If Not EnsureWord(wdApp) Then

                msg = "Word 实例不可用,已跳过"

            Else

                msg = ProcessOne(wdApp, fullPath, fileName, pdfFolder, pages)

                ' RPC 断链类错误:旧实例多半已崩溃,重建后用新进程再试一次

                If Len(msg) > 0 And IsComError(msg) Then

                    Set wdApp = Nothing

                    If EnsureWord(wdApp) Then

                        note = "(首次失败后重建 Word 实例并重试)"

                        pages = 0

                        msg = ProcessOne(wdApp, fullPath, fileName, pdfFolder, pages)

                    End If

                End If

            End If

            r = r + 1

            logSheet.Cells(r, 1).Value = r - 1

            logSheet.Cells(r, 2).Value = fileName

            logSheet.Cells(r, 3).Value = IIf(pages > 0, pages, "-")

            logSheet.Cells(r, 4).Value = modeName

            If Len(msg) = 0 Then

                If MODE = 2 Then

                    logSheet.Cells(r, 5).Value = "诊断通过:可正常打开并关闭 " & note

                Else

                    logSheet.Cells(r, 5).Value = "已处理并关闭 " & note

                End If

                nOK = nOK + 1

            Else

                logSheet.Cells(r, 5).Value = msg

                nFail = nFail + 1

            End If

        End If

        fileName = Dir()

    Loop

    '--- 7. 汇总 ---

    If nOK + nFail = 0 Then

        MsgBox "该文件夹中没有找到 Word 文档(.doc/.docx/.docm 等)。", vbExclamation

    Else

        MsgBox modeName & "完成" & vbCrLf & _

               "成功:" & nOK & " 个" & vbCrLf & _

               "失败:" & nFail & " 个" & vbCrLf & _

               "明细见工作表【打印日志】", vbInformation

    End If

CleanUp:

    On Error Resume Next

    If Not wdApp Is Nothing Then wdApp.Quit SaveChanges:=0

    Set wdApp = Nothing

    Application.ScreenUpdating = True

    On Error GoTo 0

End Sub

'------------------------------------------------------------------

' 处理单个文档:返回空串 = 成功,否则返回带阶段前缀的错误描述

' 无论成功失败,都保证把该文档关闭,再交给主循环处理下一个

'------------------------------------------------------------------

Private Function ProcessOne(ByVal wdApp As Object, ByVal fullPath As String, _

                            ByVal fileName As String, ByVal pdfFolder As String, _

                            ByRef pages As Long) As String

    Const wdDoNotSaveChanges As Long = 0

    Const wdPrintAllDocument As Long = 0

    Const wdExportFormatPDF  As Long = 17

    Const wdStatisticPages   As Long = 2

    Dim doc As Object, stage As String, errText As String

    Dim pdfPath As String, baseName As String, p As Long

    On Error GoTo EH

    stage = "打开并统计页数"

    Set doc = wdApp.Documents.Open(fileName:=fullPath, _

                                   ConfirmConversions:=False, _

                                   ReadOnly:=True, _

                                   AddToRecentFiles:=False, _

                                   Visible:=False)

    pages = doc.ComputeStatistics(wdStatisticPages)

    Select Case MODE

        Case 0

            stage = "打印"

            ' Background:=False:等打印作业完整提交到打印队列后才返回;

            ' 否则紧接着 Close 会中断 Word 后台渲染,造成漏打 / 空白页

            doc.PrintOut Background:=False, Range:=wdPrintAllDocument, Copies:=1

            If PAUSE_SEC > 0 Then Application.Wait Now + TimeSerial(0, 0, PAUSE_SEC)

        Case 1

            stage = "导出 PDF"

            p = InStrRev(fileName, ".")

            baseName = Left$(fileName, p - 1)

            pdfPath = pdfFolder & baseName & ".pdf"

            ' 直接由 Word 生成 PDF,完全不经过打印机驱动,因此不会弹"另存为"框

            doc.ExportAsFixedFormat OutputFileName:=pdfPath, _

                                    ExportFormat:=wdExportFormatPDF, _

                                    OpenAfterExport:=False

        Case 2

            stage = "诊断"

            ' 只打开并统计页数,不做任何输出

    End Select

    doc.Close SaveChanges:=wdDoNotSaveChanges   ' 处理后立刻关闭,不保存任何改动

    Set doc = Nothing

    ProcessOne = ""

    Exit Function

EH:

    errText = stage & "失败:错误 " & Err.Number & " " & Err.Description

    On Error Resume Next

    If Not doc Is Nothing Then doc.Close SaveChanges:=wdDoNotSaveChanges

    Set doc = Nothing

    On Error GoTo 0

    ProcessOne = errText

End Function

'------------------------------------------------------------------

' 健康检查:Word 进程崩溃 / 被外部关闭后 wdApp 会变成"死引用",

' 此时任何调用都会继续报 RPC 错误。这里探测失败就重建实例,

' 避免一个文件出错导致后面全部连锁失败。

'------------------------------------------------------------------

Private Function EnsureWord(ByRef wdApp As Object) As Boolean

    Dim alive As Boolean, tmp As String

    On Error Resume Next

    Err.Clear

    If Not wdApp Is Nothing Then

        tmp = wdApp.Version

        If Err.Number = 0 Then alive = True

    End If

    On Error GoTo 0

    If alive Then

        EnsureWord = True

        Exit Function

    End If

    On Error Resume Next

    If Not wdApp Is Nothing Then wdApp.Quit SaveChanges:=0

    Set wdApp = Nothing

    Set wdApp = CreateObject("Word.Application")

    On Error GoTo 0

    If wdApp Is Nothing Then

        EnsureWord = False

        Exit Function

    End If

    On Error Resume Next

    wdApp.Visible = False

    wdApp.DisplayAlerts = 0

    wdApp.AutomationSecurity = 3        ' 3 = 强制禁用文档宏,防宏 / 加载项弹窗

    wdApp.Options.SaveNormalPrompt = False

    If Len(USE_PRINTER) > 0 Then wdApp.ActivePrinter = USE_PRINTER

    On Error GoTo 0

    EnsureWord = True

End Function

Private Function IsVirtualPrinter(ByVal s As String) As Boolean

    Dim t As String

    t = LCase$(s)

    If InStr(t, "pdf") > 0 Or InStr(t, "xps") > 0 Or InStr(t, "onenote") > 0 Or _

       InStr(t, "fax") > 0 Or InStr(t, "wps") > 0 Then

        IsVirtualPrinter = True

    End If

End Function

Private Function IsComError(ByVal s As String) As Boolean

    If InStr(s, "-2147") > 0 Or InStr(s, "自动化") > 0 Or _

       InStr(s, "RPC") > 0 Or InStr(s, "462") > 0 Or InStr(s, "远程") > 0 Then

        IsComError = True

    End If

End Function

Private Function IsWordDoc(ByVal fileName As String) As Boolean

    Dim ext As String, p As Long

    If Left$(fileName, 2) = "~$" Then Exit Function   ' 排除 Word 临时锁文件

    p = InStrRev(fileName, ".")

    If p = 0 Then Exit Function

    ext = LCase$(Mid$(fileName, p))

    Select Case ext

        Case ".doc", ".docx", ".docm", ".dot", ".dotx", ".dotm", ".rtf"

            IsWordDoc = True

    End Select

End Function

Private Function GetLogSheet() As Worksheet

    On Error Resume Next

    Set GetLogSheet = ThisWorkbook.Worksheets("打印日志")

    On Error GoTo 0

    If GetLogSheet Is Nothing Then

        Set GetLogSheet = ThisWorkbook.Worksheets.Add( _

            After:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count))

        GetLogSheet.Name = "打印日志"

    End If

End Function

回首页,搜索你想要的文档

在首页搜索框输入关键词,快速定位资料

文库首页搜索指引 立即搜索

相关学习资料