userform.print

kasack · Apr 8th, 2002, 06:33 AM

Howdy
userform.print
uses the default printer.
I'd like to be able to choose
a different printer.
What do I need to add so that the
userform prints on a printer that I
choose and not the default printer ?
Path ?
node name of the printer ?

Thanks for the help

Derek · Apr 8th, 2002, 06:57 AM

Hi Kasack
Try recording a macro to print the sheet. Go to File, Print and change the name of the printer in the dropdown box to the one you want. Stop recording, then use Alt+F11 to go to the VB Editor and check the code it used.

Hope this helps
regards
Derek

Dave Hawley · Apr 8th, 2002, 06:58 AM

How about

Application.Dialogs(xlDialogPrinterSetup).Show

kasack · Apr 9th, 2002, 05:16 AM

Quote:

On 2002-04-08 05:58, Dave Hawley wrote:
How about

Application.Dialogs(xlDialogPrinterSetup).Show

Not bad, thats what I do need,
how can I now command to print on a chosen
printer ?

I choose printer 5 , ok, = print
but that method isn't working
thanks anyhow

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 06:33 AM	#1
kasack New Member Join Date: Apr 2002 Posts: 2	Howdy userform.print uses the default printer. I'd like to be able to choose a different printer. What do I need to add so that the userform prints on a printer that I choose and not the default printer ? Path ? node name of the printer ? Thanks for the help

Apr 8th, 2002, 06:57 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Kasack Try recording a macro to print the sheet. Go to File, Print and change the name of the printer in the dropdown box to the one you want. Stop recording, then use Alt+F11 to go to the VB Editor and check the code it used. Hope this helps regards Derek

Apr 8th, 2002, 06:58 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	How about Application.Dialogs(xlDialogPrinterSetup).Show