Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

VBA excel 2011 save as PDF

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • VBA excel 2011 save as PDF

    Used the following:
    Code:
    Sub SavePDFMacro()
    
        ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
            "Macintosh HD:Users:Mach7:Desktop:" & Range("AA1").Value, Quality:= _
            xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
            OpenAfterPublish:=True
    End Sub
    The set print area should be saved as a PDF file onto the desktop using as file name the value found in Cell AA1.
    The code is doing just that. No issue here.

    I would like to adjust the paper size and the margin as to maximize the appearance.
    Right now I get a pdf that is either a A4 or a 8.5 by 11.
    Any suggestion to force the pdf to save as legal that is 8.5 by 13 (215.9 by 330.91 mm). Note Excel is already using this size as default, however the created PDF does not.

    Thanks for your suggestions.

  • #2
    Re: VBA excel 2011 save as PDF

    posted on VBA Express under Mac's forum.
    link.

    Comment

    Trending

    Collapse

    There are no results that meet this criteria.

    Working...
    X