Results 1 to 2 of 2

Thread: Force pdf to Print in Landscape Mode

  1. #1

    Force pdf to Print in Landscape Mode



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2

    Any replies yet.

    Quote Originally Posted by JerryV View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •