Question

我试图将excel宏中的word文档导出为PDF，但当我尝试运行宏时，会弹出错误“未找到命名参数”并突出显示“Type:=”，我不知道是否需要添加引用或其他内容，我缺少什么？

Dim wdApp As Word.Application
Dim wdDoc As Word.Document
Dim wdCell As Word.cell

With wdDoc
        saveLocation = "https://orgindustrie-my.sharepoint.com/personal/different_person_org_com/Documents/folder/subfolder"
        .ExportAsFixedFormat Type:=xlTypePDF, _
             Filename:=saveLocation & "/" & "File" & Range("G1").Value & ".pdf"
        .Save
        .Close
End With

我对vba还很陌生，所以我不知道自己做错了什么。非常感谢你的帮助。

Answer 1

您正在合并Excel方法工作簿。ExportAsFixedFormat和Word方法文档。ExportAsFixedFormat。

Word：

Parameters

Name Required/Optional Data Type Description

OutputFileName Required String The path and file name of the new PDF or XPS file.

ExportFormat Required WdExportFormat Specifies either PDF or XPS format.

因此：

    .ExportAsFixedFormat ExportFormat:=wdExportFormatPDF, _
        OutputFileName:=saveLocation & "/" & "File" & Range("G1").Value & ".pdf"

Name	Required/Optional	Data Type	Description
OutputFileName	Required	String	The path and file name of the new PDF or XPS file.
ExportFormat	Required	WdExportFormat	Specifies either PDF or XPS format.

Parameters

友情链接