ExportasFixedFormat to PDF Issue

[Jabba1963]

Hi All,

Print Preview displays correctly - ie. page breaks are where I want them and whichever printer I select the output works as expected. However when I use the following code the resultant PDF file is ignoring the page breaks despite the IgnorePrintAreas being set to False

        ActiveSheet.ExportAsFixedFormat _
                Type:=xlTypePDF, _
                Filename:=FilenamePath, _
                Quality:=xlQualityStandard, _
                IncludeDocProperties:=True, _
                IgnorePrintAreas:=False, _
                OpenAfterPublish:=False

I have tried setting different default printers including CutePDF and BullZip PDF printers as well as other physical printers but alas no joy... the resultant output has page breaks in the wrong place.

I am running Excel 2010...

Ideas anyone ?

 

[Jabba1963]

Whey heh - problem solved...

Options - Advanced - General (right down the bottom) - Scale Content for A4 or 8.5 x 11" paper sizes

Make sure this is Unchecked... NOT Ticked... and ExportasFixedFormat then adheres correctly to the Print Preview Page Breaks...

AND most importantly of course - Print Preview still works correctly...

Hope this helps someone in the future...

Cheers
Jabba1963