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.