I think I used the printersetup dialog box in a project to allow users to
change the printer. I had a command button on the form that ran code like
this
Application.Dialogs(xlDialogPrinterSetup).Show
Then I put the activeprinter.name into a label that was on my form so users
knew what the active printer was. The code to print the worksheets was
attached to another command button.
Hope this helps.
"sarah_tennessee" wrote:
Great idea, very clever...that will work for the onsite folks. The problem
is that we are going to be sending to offsite people and I have no idea what
their printers are. :-(
"rocket0612" wrote:
maybe this will help, say there was a choice of 2 printers, and you have
a check box to select which printer to print from
Code:
--------------------
'deterime which printer to print from
If Range("A1") = true then myprinterselect = "\\BTBEAPAPP04\PBTBEA001M"
If Range("A2") = true then myprinterselect = "\\BTBEAPAPP04\PBTBEA002M"
Dim sCurrentPrinter As String
sCurrentPrinter = ActivePrinter
wrd.ActivePrinter = my printer select
--------------------
works for me anyway, good luck :)
--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=530690