The Basic code specifies selected sheets by an array of indices, a boolean constant if the output should be printed to file or printer device together with a file name and a printer name for the respective output.
Code: Select all
REM we are going to print the first and third sheet:
aSheetNums = Array(0, 2)
REM Print to file
Const bPrintToFile = True
sOutFile = ThisComponent.URL & ".pdf"
REM if not to file, specify printer name
Const cPrinterName = "PDF"