PageSetup.PaperSize property of Microsoft.Office.Interop.Excel._Worksheet is not taken during PDF print via ExportAsFixedFormat function

Vinay Jirgale 1

I am trying to print the certain cell range of excel into PDF in A3 file format. But when I open the generated PDF, the document properties show a size different than A3. Can someone help me here?

Following is the code,

 oWB = oXL.Workbooks.Open(excelPath, false, false, Type.Missing, "", "", true, XlPlatform.xlWindows, "", false, false, 0, false, true, 0);
    oSheet = (_Worksheet)oWB.ActiveSheet;


    oSheet.PageSetup.FitToPagesWide = 1;
    oSheet.PageSetup.FitToPagesTall = 1;

    oSheet.PageSetup.PrintArea = "$A$1:$W$40";
    oSheet.PageSetup.Orientation = XlPageOrientation.xlLandscape;
    oSheet.PageSetup.PaperSize = XlPaperSize.xlPaperA3;
    oSheet.PageSetup.Zoom = false;


    oSheet.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF, pdfPath, XlFixedFormatQuality.xlQualityMinimum, true,false);

When I check the PDF, it is not in A3 format.

Thank you.

Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor

2021-12-17T02:54:47.757+00:00

Hi @Vinay Jirgale ,
Your problem is related to Office code, I added the tag "office-vba-dev". The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
kinuasa 361 Reputation points

2021-12-17T07:07:47.833+00:00

I recommend that you try specify the virtual printer with the ActivePrinter property.
oXL.ActivePrinter = "Microsoft Print to PDF on Ne10:";
Vinay Jirgale 1 Reputation point

2021-12-17T11:53:35.833+00:00

Thank you.
Vinay Jirgale 1 Reputation point

2021-12-17T11:54:20.22+00:00

I tried the code suggested by you, but it had thrown a COM exception.( With my network details)

ex = {"Exception from HRESULT: 0x800A03EC"}
kinuasa 361 Reputation points

2021-12-21T01:34:54.313+00:00

Printer port name(Ne**) differs depending on what computer you try.
The following site may be helpful.

https://learn.microsoft.com/en-us/office/vba/api/excel.application.activeprinter
https://stackoverflow.com/questions/5424932/how-to-determine-what-ne-port-the-adobe-pdf-printer-is-on

Share via

PageSetup.PaperSize property of Microsoft.Office.Interop.Excel._Worksheet is not taken during PDF print via ExportAsFixedFormat function