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
the web designer group uk
the webdesigner group logo

Close Button

Web Site Designed by

The Web Designer Group