Pinterest Pixel

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... read more

Download Excel Workbook
Bryan
Posted on

Overview

Save Each Worksheet as a PDF File Using Macros In Excel | MyExcelOnline Save Each Worksheet as a PDF File Using Macros In Excel | MyExcelOnline

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: 

Save Each Worksheet as a PDF File Using Macros In Excel

Exercise Workbook:

Save Each Worksheet as a PDF File Using Macros In Excel | MyExcelOnline

Download excel workbookSave-Each-Worksheet-as-a-PDF-File.xlsm


We want to export these worksheets into pdf files:

Save Each Worksheet as a PDF File Using Macros In Excel

STEP 1: Go to Developer > Code > Visual Basic

Save Each Worksheet as a PDF File Using Macros In Excel | MyExcelOnline

 

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.

Save Each Worksheet as a PDF File Using Macros In Excel

 

STEP 3: Let us test it out!

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

Save Each Worksheet as a PDF File Using Macros In Excel | MyExcelOnline

 

Make sure your macro is selected. Click Run.

Save Each Worksheet as a PDF File Using Macros In Excel

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

 Save Each Worksheet as a PDF File Using Macros In Excel

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

Save Each Worksheet as a PDF File Using Macros In Excel

 

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

 

101 Macros Book

If you like this Excel tip, please share it
Save Each Worksheet as a PDF File Using Macros In Excel | MyExcelOnline Save Each Worksheet as a PDF File Using Macros In Excel | MyExcelOnline
Save Each Worksheet as a PDF File Using Macros In Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Print All Comments of a Worksheet Using Macros In Excel

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...