Zoom Error: Switch from a postscript printer

etlee · Post by **etlee** » Fri Sep 24 2004

Hello,

In excel vba, after i call the EnablePrinter and SetDefaultPrinter functions from a postscript printer, the pagesetup.zoom function(programmatically) is zooming in the opposite direction. It means when i decrease the zoom value, i am actually zooming in, instead of zoom out.

i am using Xerox Phaser 4500DT PS, also i try some HP and Cannon Postscript printer, they all have the same problem. I do not experience the same problem when i switch from a non postscript printer.

is there a fix for it?

Thank you

Joan · Post by **Joan** » Tue Sep 28 2004

Hello,

EnablePrinter and SetDefaultPrinter are made to be used with the Amyuni PDF Converter printer, which is not a Postscript printer.

Why are you using these functions with physical printers?

Thanks

etlee · Post by **etlee** » Tue Sep 28 2004

Hi,

We have an application written in Excel VBA and we use the PDF driver to generate our Execel report. Before I call EnablePrinter and SetDefaultPrinter to initialize the PDF driver, my default printer is set to Xerox Phaser 4500DT PS, which I think is a PostScript printer driver. Before I send the report to the PDF driver, I would adjust the PageSetup.Zoom property in Excel programmatically to make sure that the report would fit in one page. When I decrease the Zoom value, the print area is supposed to shrink, but instead it enlarges. We don't have the problem if our default printer is set to a non-postscript printer driver. We also try other PostScript drivers for HP and Cannon printers and they all have the problem.

Post by **Jose** » Wed Sep 29 2004

Hello,

Can you please confirm if you mean that the "print area" on the resulting PDF document?

Thanks