Selecting a printer in an Excel 2007 Userform [Solved/Closed]

Question

Selecting a printer in an Excel 2007 Userform [Solved/Closed]

Report

hbrewer - Apr 28, 2010 at 08:27 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- Apr 28, 2010 at 09:21 AM

I am using the following code:
Private Sub CommandButton1_Click()

Application.Dialogs(xlDialogPrint).Show
UserForm1.PrintForm

End Sub

I can show all of the printers attached to my computer, but will not print to any other but the default printer. Can anyone help me?
Thanks

Selecting a printer in an Excel 2007 Userform
Excel 2007 "If....Then select Row and move&qu ✓ - Forum - Excel
Spell number in excel 2007 indian rupees download ✓ - Forum - Office Software
Cascading combo boxes excel vba userform - How-To - Excel
Date format not changing in excel 2007 ✓ - Forum - Excel
Spell number in India Rupee - Forum - Office Software

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-04-28T08:32:08-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

763
Apr 28, 2010 at 08:32 AM

You have to set the active printer as for example

Application.ActivePrinter = "PDF995 on Ne00:"

Report

hbrewer
Apr 28, 2010 at 09:02 AM

Is this instead of:
Application.Dialogs(xlDialogPrint).Show

Report

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

763
Apr 28, 2010 at 09:21 AM

Yes. In code you are saying what printer to go to. In the example above, I am sending to PDF995

Selecting a printer in an Excel 2007 Userform [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!