posted on VBA Express under Mac's forum.
Used the following:
The set print area should be saved as a PDF file onto the desktop using as file name the value found in Cell AA1.VB: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 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)