Save Each Worksheet as a PDF File Using Macros In Excel

Want to export and save each worksheet as a PDF file? You can do that with a single click using Excel Macros!

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Save each worksheet as a PDF file

Copy Source Code:

Sub SaveEachWorksheetAsPdfFile()

Dim worksheet As Worksheet

'Loop through all of the worksheets
'Remember to change the folder directory as well
For Each worksheet In Worksheets
worksheet.ExportAsFixedFormat xlTypePDF, "C:\ChangeMe\" & worksheet.Name & ".pdf" 
Next worksheet

End Sub

Final Result: 

Exercise Workbook:

---

We want to export these worksheets into pdf files:

STEP 1: Go to Developer > Code > Visual Basic

 

STEP 2: Paste in your code and Select Save.

Remember to change the directory on where you want to save the pdf files. Close the window afterwards.

 

STEP 3: Let us test it out!

Open the sheet containing the data. Go to Developer > Code > Macros

 

Make sure your macro is selected. Click Run.

Let us check the folder, and you will see these worksheets:

 

Let us open one of the files, and it is exactly the same as the one in the workbook!

 

How to Save Each Worksheet as a PDF File Using Macros In Excel