ARTICLE · 1367698
批量打印word文档
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















































































