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






Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us

Datanology