is there a macro that can convert a sheet to pdf using all the pdf page?

[tonywatsonhelp]

Hi everyone,

i have a problem
when i create a pdf of a sheet the page does not fill the entire pdf page,
I've tried everything i can but i still get a small amount of pdf white page around the outside
is there a vbac ode or way to get the pdf to exactly represent the excel sheet i use a header that goes from left to right butt in the pdf it about 1 cm from each side?

thanks

Tony

 

[ChrisFoster]

How are you currently creating the PDF, is it through print to PDF?

 

[tonywatsonhelp]

heres a randon typical print to pdf code i use

Sub Create_PDF2()
Application.ScreenUpdating = False
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
    Filename:=ActiveWorkbook.Path & "\Paid and AR Report " & Format(Now, "MM-DD-YYYY") & ".pdf", _
    OpenAfterPublish:=True

End Sub

 

[ChrisFoster]

Try this.

Sub Create_PDF2()
Application.ScreenUpdating = False
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
    Filename:=ActiveWorkbook.Path & "\Paid and AR Report " & Format(Now, "MM-DD-YYYY") & ".pdf", _
    IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True

End Sub

 

[tonywatsonhelp]

Hi Chris,
thanks,
i'll have a play about see if this helps

 

[ChrisFoster]

Let me know if that has worked or not.