[RESOLVED] setting up the printer

[almagg]

i want the user to set up the printer.
when we go to File/Print, the dialog box comes up and we can select
the printer and other options. then, when we click 'ok' the document is sent to the printer. this is what i DO NOT want to happen.

also, the document gets printed on 11x17 paper. well in order for 11x17 to be an option in the page set up dialog box, the correct printer has to be selected first. the code was working and i switched printers and the code errored out in the page set up portion at the 11x17 line.

what i would like to open up using code is the Start/Printers and Faxes window. i tried recording a macro but it did not record.

thanks

[almagg]

got it.

Application.Dialogs(xlDialogPrinterSetup).Show