willsonlincake 发表于 2022-4-10 22:38:39

VBA保存工作簿为PDF

Sub SaveWorksheetAsPDF()
Dim ws As Worksheet
For Each ws In Worksheets
ws.ExportAsFixedFormat _
xlTypePDF, _
"Folder-Name" & _
ws.Name & ".pdf"
Next ws
End Sub
页: [1]
查看完整版本: VBA保存工作簿为PDF