+ Reply to Thread
Results 1 to 4 of 4

define page size

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    define page size

    i use the code below to print a PDF...for some reason the page size is coming out as 11.81X15.28...is there a way to define the page size as 8.5x11?

      PdfFile = ActiveWorkbook.FullName
      i = InStrRev(PdfFile, "CURRENT PROJECTS")
      If i > 1 Then PdfFile = Left(PdfFile, i - 1)
      PdfFile = "CURRENT PROJECTS" & ".pdf"
     
      ' Export activesheet as PDF
        Worksheets("ACTIVE PROJECTS").Range("B3:H175").ExportAsFixedFormat _
         Type:=xlTypePDF, Filename:="S:\" & PdfFile, Quality:=xlQualityStandard, _
          IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
      Shell "cmd /S " & """" & PdfFile & """", vbNormal

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,441

    Re: define page size

    .
    Resource: http://stackoverflow.com/questions/1...t-in-excel-vba

    Resource: http://blogs.adobe.com/acrolaw/2015/...nd-dimensions/

    Resource: http://www.mrexcel.com/forum/excel-q...lications.html

    Everything I've read indicates it is not your coding. Has to do with the Printer Selection or settings in Windows.

  3. #3
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    Re: define page size

    Yeah that's how i was adjusting it in the past...something must have changed on my end that caused the paper layout to change. Thanks for the links! I will look into further, if i find anything different I'll post a reply. Thanks again!

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,441

    Re: define page size

    Thank you for the Add Rep.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Changing Page Size - Only gives label size options
    By etouch in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-31-2016, 02:40 PM
  2. Define named range where user can define size
    By nahousto in forum Excel General
    Replies: 4
    Last Post: 07-06-2009, 05:09 PM
  3. Auto size a pivot table to a page size
    By *.* in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2006, 12:09 AM
  4. How to define table size
    By carlos10 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2006, 01:35 PM
  5. change cell size from page to page on the same worksheet
    By Danny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2005, 03:25 PM
  6. How do you define a custom paper size in Excel? (i.e. 11x17)
    By Marcin Rembisz in forum Excel General
    Replies: 1
    Last Post: 09-21-2005, 10:05 AM
  7. Define Page Setup for whole workbook
    By AliH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2005, 12:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1