BCL easyPDF SDK
easyPDF SDK Usermanual
PDF Creator Programming API  |  Download Free Trial  |  Contact Us to Purchase

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.8")

Set oPrintJob = oPrinter.ExcelPrintJob
oPrintJob.PrintAllSheets = True

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