Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic Print Paper Size Reformat (Excel 2000)

    I often get documents from Asia that are page formatted using A4 size print paper. Every time I print, I need to re-select paper and reformat. Is it possible to reformat into Letter size paper automatically ?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automatic Print Paper Size Reformat (Excel 200

    Select Tools>Options...
    There is an option on the International tab to allow automatic A4/Letter paper resizing.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Automatic Print Paper Size Reformat (Excel 2000)

    You can add a line like this to some macro
    <pre> ActiveSheet.PageSetup.PaperSize = xlPaperLetter</pre>


    If desired it can be added to the sheets before print event or you can just have a macro in your personal.xls that goes thru each sheet and changes it in the activeworkbook

    Steve

    <pre>Sub ChangePaperSizeToLetter()
    Dim wks As Worksheet
    For Each wks In ActiveWorkbook.Worksheets
    wks.PageSetup.PaperSize = xlPaperLetter
    Next
    End Sub</pre>


Posting Permissions

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