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"
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