Hi
My excel application generates a few PDF reports. I need to print them out but I would like to print two pages per one paper sheet to save our nature
This is my code, which prints one page per sheet:
Is there a way to make macro print two pages per sheet? Is my approach correct or should I use different control?
Thanks for any help
My excel application generates a few PDF reports. I need to print them out but I would like to print two pages per one paper sheet to save our nature
This is my code, which prints one page per sheet:
Code:
UserForm1.AcroPDF1.setShowToolbar False
UserForm1.AcroPDF1.setShowScrollbars False
UserForm1.AcroPDF1.LoadFile ("C:\mfwin\M2M\M2M_M2MDAILY_KRAKOWIA.pdf")
UserForm1.Repaint
UserForm1.AcroPDF1.printAll
Thanks for any help