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.
Microsoft Excel does not support the printing of empty Excel documents. As such our SDK will not convert empty documents and will instead throw a 'Conversion Failed' error.
Set oPrinter = CreateObject("easyPDF.Printer.8") Set oPrintJob = oPrinter.ExcelPrintJob ' Set Excel specific option oPrintJob.PrintAllSheets = True oPrintJob.PrintOut "C:\test\input.xls", "C:\test\output.pdf"