I want to unify the size of the PDF created in Excel VBA (in VBA).

I implemented the PDF version of the Excel sheet in the VBA, but some pages are not consistent in size.

The reason seems to be the same as the link below.

When you create a PDF from Excel, the page size varies

It seems that the output PDF is opened in Acrobat and re-PDFed in PDFPrinter, but I would like to do all of this on the VBA.

Even if it is not the above proposal, if the PDF size can be unified, there will be no problem.

Thank you for your cooperation.

vba pdf

2022-09-30 20:17

2 Answers

Excel print settings are available on each sheet.I think it was reflected only in the current sheet even if I selected more than one sheet.Therefore, please set the print settings for each sheet, then select multiple sheets to print.

2022-09-30 20:17

Convenient and easy-to-use components are recommended, and you can easily convert Excel documents into PDFs through the free Spire.XLS for .NET.

See this article for detailed instructions:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Conversion/Convert-worksheet-to-PDF-in-C-VB.NET.html

2022-09-30 20:17

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656