I'm using Version 1.6.2 of PDF Creator on a Windows 8 laptop in Excel as part of Office 365 Home Premium.
When I use:
Workbooks().Printout copies:=1, ActivePrinter:="PDFCreator"
I get a multi-page PDF file with new pages starting for each of the sheets in the workbook. The pages correctly maintain the orientation as specified by each sheet's printing orientation, in which some are landscape and some are portrait. It's beautiful.
However, when I use this exact same code between print outs of portrait-oriented pages, and then use .cCombineAll, all the pages in the document go portrait, including the ones that correctly printed landscape when in their own document. It's ugly.
This would be a work-around: Is there a setting for programmatic control of PDFCreator that will specify the orientation for each print job before combining? I've read that AutoRotate doesn't work. But if there were a controlled setting that worked, I could break the Excel workbook with multiple pages into different print jobs for each orientation. If this functionality isn't there, it's definitely expected to be there, and needed.
From the previous discussions, this appears to be a PDFCreator bug, or at least an issue for which a public work-around has not been found. What's different in my experience, which I haven't seen discussed elsewhere, is that one document -- such as one spreadsheet with multiple sheets -- can have both orientations in it.
I see there's a similar thread, "[Combined documents] page rotation issue", but since it is full of lengthy repeated error messages, and I am presenting here a potential workaround for some situations, I'm starting a new thread.