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

Help
1

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!

2

@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)
    Sheets().Select
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=filePath, _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False
End Sub
3

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.

image
image739×477 44.9 KB