Puzzling over when Excel starts a new print job with pdf output

A

AnandaSim

Hi All,

I've a request to output PDF from Excel. And the source is from
several worksheets. So I group select the worksheets, carry out

ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:=kChosenPrinterName

I would expect either one continuous stream of pages in one print job
or separate print jobs per worksheet. But the output is inconsistent
depending on which pdf printer driver I use. There is a mix of
portrait and landscape layouts but that does not seem to be the
critical factor.

Anyone have experience with the phenomenon of how Excel decides to
group sheets for printing? any tips?

Thanks,

Ananda
 
Top