Force pdf to Print in Landscape Mode

JerryV

New member
Joined
Oct 16, 2013
Messages
1
Reaction score
0
Points
0
How can I use vba to create a pdf from an excel worksheet and force it to print in Landscape mode?
The worksheet is configured for Landscape.
I've tried the Excel Publish to pdf app as well as Ken's PdfCreator code.
The print default always comes up as portrait.
This is very frustrating as I create beautiful landscape pdf's but invariably someone will print 50 copies in the default portrait mode for a meeting.
 

jimmydd123

New member
Joined
Dec 29, 2015
Messages
3
Reaction score
0
Points
0
Any replies yet.

How can I use vba to create a pdf from an excel worksheet and force it to print in Landscape mode?
The worksheet is configured for Landscape.
I've tried the Excel Publish to pdf app as well as Ken's PdfCreator code.
The print default always comes up as portrait.
This is very frustrating as I create beautiful landscape pdf's but invariably someone will print 50 copies in the default portrait mode for a meeting.

Hi, I have a similar issue. I have modified and added to Ken's code so I can print autocad drawings from an excel transmittal workbook. I am also having trouble with landscape. The drawing is perfect and will print correctly but displays sideways. Is there an example piece of code I can add that would rotate the page?

Thanks for this awesome forum.
 
Top