• 使用VBA将批量的WORD文档转换为PDF


    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 If
    End Sub
    
    Function 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 With
    End Function
    
    Function GetFolderPath()
        Dim folderPath As String
        With Application.FileDialog(msoFileDialogFolderPicker)
            .AllowMultiSelect = False
            .Title = "请选择要存放的目录"
            If .Show = -1 Then
                GetFolderPath = .SelectedItems(1)
            End If
        End With
    End Function
    
    Sub 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.Close
    End Sub
    

      

  • 相关阅读:
    [BZOJ 3282] Tree 【LCT】
    [BZOJ 2049] [Sdoi2008] Cave 洞穴勘测 【LCT】
    [BZOJ 1036] [ZJOI2008] 树的统计Count 【Link Cut Tree】
    [HDOJ
    Excel+DDT数据驱动实例
    jenkins+SVN配置
    [转]loadrunner:系统的平均并发用户数和并发数峰值如何估算
    loadrunner:Auto Correlate自动定位瓶颈
    loadrunner:判断是否服务器连接池瓶颈
    利用page_source抓取网页中的URL,进行链接测试
  • 原文地址:https://www.cnblogs.com/beta2013/p/3666077.html
Copyright © 2020-2023  润新知