My worksheets are being resized to 12.69 x 16.42 inches when I use the following code:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Temp\Unit1DailyReport", IncludeDocProperties:=True, OpenAfterPublish:=True
I verified the sheets are sized to 8.5 x 11.
I searched previous inquiries, found only 2 (only 1 was relevant). It suggested placing the following code just prior to the ExportAsFixedFormat statement.
ActiveSheet.PageSetup.PaperSize = xlPaperLetter
I tried this and still receive PDF's of the size 12.69 x16.42 inches.
Your help is appreciated, thank you.
Bookmarks