PrintAllSheets Property

Enable/Disable the flag that indicates whether to print all Excel worksheets or not.

Type: Boolean

Remarks

By default, only the active worksheet will be printed. Use this property if you need to print all worksheets.

Example Usage

Set oPrinter = CreateObject("easyPDF.Printer.5")

Set oPrintJob = oPrinter.ExcelPrintJob
oPrintJob.PrintAllSheets = True

oPrintJob.PrintOut "C:\input.xls", "C:\output.pdf"

<<