User ability to select printer

jgoulart · Mar 10th, 2002, 03:12 PM

Using the printout command, I don't see a way to allow the user to change his printer. Is there anyway to get the user to specify the printer or to change copies. I can see how to set the ammount of copies but I can't seem to figure out how to give the user an option (when his print command is disabled) to select the printer on a printout other than use a print preview option.

John

Jack in the UK · Mar 10th, 2002, 03:19 PM

Hi --

Click file
click print

see the white section middle top ish, to the right is a arrow/drop down click it. A box apperars that aallows prit selection to any printer is networked or whatever.

Does this help or im misunderstood, sorry

I guess in code try record it and set the network to that default printer, should record ok, but paper selection ie dula bin lazers or manual seems to be effected by the software attached to that printer as does dublex printing.

MY fix is not to print at all, save as unique file name and save in dir made called PRINT and todays date and thend default excel to what printer and papers typr and location and all the rest and then print 1 or all saved docs.

_________________
Good Luck
HTH

Rdgs
==========
Jack in the UK

[ This Message was edited by: Jack in the UK on 2002-03-10 14:23 ]

SamS · Mar 10th, 2002, 05:52 PM

try Application.Dialogs(xlDialogPrinterSetup).Show or more appropriately I think you want

Application.Dialogs(xlDialogPrint).Show

[ This Message was edited by: SamS on 2002-03-10 16:55 ]

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

Mar 10th, 2002, 03:12 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	Using the printout command, I don't see a way to allow the user to change his printer. Is there anyway to get the user to specify the printer or to change copies. I can see how to set the ammount of copies but I can't seem to figure out how to give the user an option (when his print command is disabled) to select the printer on a printout other than use a print preview option. John

Mar 10th, 2002, 03:19 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi -- Click file click print see the white section middle top ish, to the right is a arrow/drop down click it. A box apperars that aallows prit selection to any printer is networked or whatever. Does this help or im misunderstood, sorry I guess in code try record it and set the network to that default printer, should record ok, but paper selection ie dula bin lazers or manual seems to be effected by the software attached to that printer as does dublex printing. MY fix is not to print at all, save as unique file name and save in dir made called PRINT and todays date and thend default excel to what printer and papers typr and location and all the rest and then print 1 or all saved docs. _________________ Good Luck HTH Rdgs ========== Jack in the UK [ This Message was edited by: Jack in the UK on 2002-03-10 14:23 ]

Mar 10th, 2002, 05:52 PM	#3
SamS Board Regular Join Date: Feb 2002 Location: Brisbane, Down Under Posts: 533	try Application.Dialogs(xlDialogPrinterSetup).Show or more appropriately I think you want Application.Dialogs(xlDialogPrint).Show [ This Message was edited by: SamS on 2002-03-10 16:55 ]