Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to set the printer and the paper size and Page format in the macro.
I did not try it myself, but maybe you can use the following:
Set Application.Printer = Application.Printers("HP LaserJet Series II")
ws.PageSetup.PaperSize = xlPaper11x17
I tried it but the macro doesn't accept even the first line
Set Application.Printer = Application.Printers("Bullzip PDF Printer")
ws.PageSetup.PaperSize = xlPaper11x17
is there any syntax error? where "ws" is defined as a parameter?
any ideas?
thanks
Bumin