How to Split Excel Sheets into Individual PDF Files

When working with Excel file, you can save an Excel file as a PDF file, however, this is to save one Excel file into PDF. When you need to convert many Excel tabs into individual PDF files, please follow the steps below:

Step 1: Pressing shortcut "Alt+F11" to open the Microsoft Visual Basic for Applications window;

Alternatively, please click the "Developer" tab from the ribbon and click "Visual Basic" to open the window.

Step 2: In the new window, click the "Insert" tab from the ribbon, and click "Module";

Step 3: Copy and paste the following codes in the Module window;

Sub ExportAsPDF()

Dim Folder_Path As String

With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Select Folder path"
If .Show = -1 Then Folder_Path = .SelectedItems(1)
End With

If Folder_Path = "" Then Exit Sub

Dim sh As Worksheet

For Each sh In ActiveWorkbook.Worksheets
sh.ExportAsFixedFormat xlTypePDF, Folder_Path & Application.PathSeparator & sh.Name & ".pdf"
Next

MsgBox "Congratulations!"

End Sub

Step 4: Click the "Run Sub" button (or press the F5 key) to run the codes;

Step 5: Select the file path that they are going to be saved;

Step 6: All worksheets will be saved as individual PDF files in the folder.

Leave a Reply