Save Each Worksheet as a PDF File Using Macros In Excel

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:

</p>
<p>Sub SaveEachWorksheetAsPdfFile()</p>
<p>Dim worksheet As Worksheet</p>
<p>'Loop through all of the worksheets<br />
'Remember to change the folder directory as well<br />
For Each worksheet In Worksheets<br />
worksheet.ExportAsFixedFormat xlTypePDF, &amp;quot;C:\ChangeMe\&amp;quot; &amp;amp; worksheet.Name &amp;amp; &amp;quot;.pdf&amp;quot;<br />
Next worksheet</p>
<p>End Sub</p>
<p>

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