I have a macro that saves the print area to a pdf file and automatically names it according to the company naming convention that is required. I did not realize that the saving was not taking up the page. I would like the print area to be one full page wide.
I'm thinking that if I go to the print menu while recording a macro that I can capture the code to make it do as I need. But, I thought I would check with some experts beforehand. I use this sheet about a hundred times a day give or take.
Here is my macro:
Sub SaveAsPDF()
'Publish file as a custom pdf
'(ThisWorkbook.Path &
'Sub SaveToRelativePath()
'Dim relativePath As String
'relativePath = ThisWorkbook.Path & "\" & ActiveWorkbook.Name
'ActiveWorkbook.SaveAs filename:=relativePath
'ChDir "C:\Users\phillip.gwinn\Desktop"
Application.Goto Reference:="Print_Area"
ChDir ThisWorkbook.Path
Selection.ExportAsFixedFormat Type:=xlTypePDF, filename:= _
Range("r7"), Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
End Sub
Bookmarks