In this tutorial you will learn how to save each worksheet as a separate PDF file using VBA macro programming in Microsoft Excel
VBA Code:
'This code will save each worsheet as a separate PDF
Sub SaveEachAsPDF()
Dim ws As Worksheet
For Each ws In Worksheets
ws.ExportAsFixedFormat xlTypePDF, "D:\demo\" & ws.Name & ".pdf"
Next ws
MsgBox ("Worksheets are successfully saved")
End Sub
Негізгі бет How to save each worksheet as a separate PDF
Пікірлер: 10