Help! PDF prints out to a different size than print preview?

[tonywatsonhelp]

Hi Everyone,
ok a very confusing problem here.
I have a Macro that save a tab as a PDF, (See macro below)
The problem I have is that it doesn't save the PDF in the same page sizes as I see in print preview
I'm trying to get the document to save as a PDF using the printer settings I have but its not doing it,
I want it to save as "Letter" size but it seams to be saving the PDF as A4 which is the UK standard size.

Any ideas how I can get it to Save as letter size or save as if it was printing but to PDF?

The macro I'm using is this:

Sub ExportAsPDF3()
ActiveSheet.Unprotect
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=ActiveWorkbook.Path & "\" & ActiveSheet.Range("L1").Value & Format(Now, "MM-DD-YYYY") & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=True
ActiveSheet.Protect
 Range("Am11").Select
End Sub

any help would be great

thanks

Tony

 

[Andrew Poulsom]

For me in Excel 2010 the PDF has exactly the same print settings as those for the ActiveSheet in Excel, including paper size. Are you sure that you have set it to Letter?

 

[tonywatsonhelp]

Hi yes, its set on letter as when I look at print preview or even print out its perfect, but when I run the macro the pages are a different size?
it very strange, I've been trying to sort it out for days now but cant get anywhere!
I'm in 2013,
I was hoping someone would know what I'm doing wrong?

 

[Andrew Poulsom]

Nope, your code also works for me in Excel 2013.

 

[tonywatsonhelp]

Well I guess for now I'll stick to my very Heath Robinson way of fixing it,
I added to the macro a copy sheet function, then on the copied tab reset the page breaks, select the page breaks I want and create the pdf from the copied tab then when its done it deletes the copied tab, problem solved.
I guess it will be one of those strange little bugs I'll never properly fix, but this works so it will have to do.

thanks
for testing and trying to sort it out for me.
Tony