I'm using VBA in an Excel workbook to sequentially print off a number of workbooks using PDFCreator COM. I wait until all the documents have been spooled to PDFCreator than use Combine All to save them to one PDF document
Some the workbooks are set to print in landscape and some in portrait. This provides the best viewing experience when using PDF format.
When I use Combine All in PDFCreator the orientation always follows the first document in the list of documents i.e if the first document is landscape than all the portrait based documents will rotate horizontally. Similarly if the first document is portrait, than all the landscape document will be rotated vertically.
I've also varified this behavior when manually printing
How do I get the orientation to be maintained for each section of the combined document?