How To Select All Sheets in Excel and Save as a PDF

I would like to be able to “Select All Sheets” and then save the existing Excel as a PDF.

I’m having trouble “Selecting all Sheets”. I have tried using hotkeys as well as screen recording. Once the all sheets have been selected, I would like to save to PDF, but the export to PDF is for Word Scope Applications.

Any insight, assistance would be great!

@abrahamdaniels you can use the below XAML. You’ll need to put the code below in a text file (named “AllSheetsToPDF.txt”) saved in the project directory with the XAML. It invokes the below VBA on a file selected at runtime. It creates the PDF in the project directory but this can be modified to suit your needs.

ExcelToPDF.xaml (7.0 KB)

Sub Main(filePath As String)
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=filePath, _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False
End Sub

If you don’t like the idea to use VBA, there is also an Excel feature to create a PDF. The alt-combo for Excel 2010 is Alt+fdpa

But, then you would need to automate the options to select Entire Workbook or whatever else and uncheck the Open File after publishing.