Hi all,
I have a database which selects Excel files and turns them to PDF.
If I open the PDF it shows each Excel sheet as a page.
The PDF shows the document the right way up regardless of orientation (some pages look portrait and some look landscape).
Even though the sheets look as Id expect (orientation), when I print it is treating the landscape sheet as though they are portrait and cutting half the page out.
Is there anyway to overcome thisin VBA?
Thanks
I have a database which selects Excel files and turns them to PDF.
If I open the PDF it shows each Excel sheet as a page.
The PDF shows the document the right way up regardless of orientation (some pages look portrait and some look landscape).
Even though the sheets look as Id expect (orientation), when I print it is treating the landscape sheet as though they are portrait and cutting half the page out.
Is there anyway to overcome thisin VBA?
Thanks