VBA - Print PDF, but maintain A4 print margins whatever the screen resolution of the PC.

[cjndev]

VBA - Print PDF, but maintain A4 print margins whatever the screen resolution of the PC.

I have the current code which selects the PDF printer of whatever PC it is used on, however depending on the screen resolution of the PC the margins will change so the printed PDF looks different depending on which PC is used.
I am looking for a way to print the same PDF on whatever PC or resolution the spreadsheet is opened on.

Please Login or Register  to view this content.

Any help greatly appreciated.

[torachan]

the print routine in the attached file may be useful - try changing a few of the margin setting in the code - needs a USB stick in a USB drive to complete the print/save cycle.