博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
使用VBA将批量的WORD文档转换为PDF
阅读量:4342 次
发布时间:2019-06-07

本文共 2033 字,大约阅读时间需要 6 分钟。

Sub BatchConvertToPDF()    Dim destFolderPath As String    destFolderPath = GetFolderPath    If destFolderPath <> Empty Then        Dim path As Variant        For Each path In GetFilePaths()            Dim indexOfSlash, indexOfDot As Integer            indexOfSlash = InStrRev(path, "\")            indexOfDot = InStrRev(path, ".")                        Dim destFilePath As String            destFilePath = destFolderPath + Mid(path, indexOfSlash, indexOfDot - indexOfSlash) + ".pdf"                        ConvertToPDF path, destFilePath        Next path    End IfEnd SubFunction GetFilePaths()    Dim folderPath As String    With Application.FileDialog(msoFileDialogFilePicker)        .Filters.Add "word文件", "*.doc; *.dotx; *.docm"        .Title = "请择要转换的word文件"        If .Show = -1 Then            Set GetFilePaths = .SelectedItems        End If    End WithEnd FunctionFunction GetFolderPath()    Dim folderPath As String    With Application.FileDialog(msoFileDialogFolderPicker)        .AllowMultiSelect = False        .Title = "请选择要存放的目录"        If .Show = -1 Then            GetFolderPath = .SelectedItems(1)        End If    End WithEnd FunctionSub ConvertToPDF(srcPath As Variant, destPath As String)    Documents.Open FileName:=srcPath, ConfirmConversions:=False, _        ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _        PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _        WritePasswordTemplate:="", Format:=wdOpenFormatAuto, XMLTransform:=""    ActiveDocument.ExportAsFixedFormat OutputFileName:= _        destPath, ExportFormat:= _        wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:= _        wdExportOptimizeForOnScreen, Range:=wdExportAllDocument, From:=1, To:=1, _        Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _        CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _        BitmapMissingFonts:=True, UseISO19005_1:=False    ActiveDocument.CloseEnd Sub

  

转载于:https://www.cnblogs.com/beta2013/p/3666077.html

你可能感兴趣的文章
02-环境搭建
查看>>
spring第二冲刺阶段第七天
查看>>
搜索框键盘抬起事件2
查看>>
阿里百川SDK初始化失败 错误码是203
查看>>
透析Java本质-谁创建了对象,this是什么
查看>>
BFS和DFS的java实现
查看>>
关于jquery中prev()和next()的用法
查看>>
一、 kettle开发、上线常见问题以及防错规范步骤
查看>>
eclipse没有server选项
查看>>
CRC码计算及校验原理的最通俗诠释
查看>>
使用Gitbook来编写你的Api文档
查看>>
jquery扩展 $.fn
查看>>
Markdown指南
查看>>
influxDB的安装和简单使用
查看>>
JPA框架学习
查看>>
JPA、JTA、XA相关索引
查看>>
机器分配
查看>>
php opcode缓存
查看>>
springcloud之Feign、ribbon设置超时时间和重试机制的总结
查看>>
观看杨老师(杨旭)Asp.Net Core MVC入门教程记录
查看>>