ExcelPrintJob Object Description

This object is a specialized version of PrintJob object. In addition to all the features from PrintJob object, ExcelPrintJob object includes numerous Excel specific features.

If you need to set Excel specific options, use this specialized object instead of generalized PrintJob object. However, do not use this object for printing documents other than the ones Excel can handle.

Example Usage


Set oPrinter = CreateObject("easyPDF.Printer.5")
Set oPrintJob = oPrinter.ExcelPrintJob
' Set Excel specific option
oPrintJob.PrintAllSheets = True
oPrintJob.PrintOut "C:\input.xls", "C:\output.pdf"

 

 

<<