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
