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
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