Pagesize issue using xlTypePDF

[me_gem69]

I am using the following code to publish my worksheet to PDF format.
In my code i have mentioned pagesize as A4 but when the PDF is published the size of the document is 13.71 x 17.74 in. which is nowhere near to A4.
How can i handle the page size here.

Please Login or Register  to view this content.