Print to PDF

[#1]

Hi,

Is it possible to set the printer and the paper size and Page format in the macro.

[#2]

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

[bumin]

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