Tag Archives: Create a PDF in Excel

Create a PDF from Excel workbook or range

Creating a PDF directly from an Excel worksheet is simple with the following VBA Example: FName = “Datanology Dashboard Example” Sheets(“PDF”).Select Range(“A1:BP89”).Select Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ “C:\Datanology\” & FName & “.pdf”, Quality _ :=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False _ , OpenAfterPublish:=True

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group