Force pdf to Print in Landscape Mode

J

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.
 
Any replies yet.

JerryV said:
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.
Click to expand...

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.
 
You must log in or register to reply here.
Back
Top