Creating custom sized PDFs from MS Excel using VBA Macros

141 Views Asked by At

I created an MS Excel macro that generates payment receipts as PDF files. I created a receipt template in one of the tabs. When the code is run the macro loads values from another tab into the template and generates PDF from the template tab. However the page sizes available in Excel are very limited. My receipt size is probably a bit smaller than A5. Is there any way I can customize the page size on VBA so that my receipts looks more neat?

0

There are 0 best solutions below