Selecting a printer in an Excel 2007 Userform
Solved/Closed
hbrewer
-
Apr 28, 2010 at 08:27 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Selecting a printer in an Excel 2007 Userform
- Excel 2007 "If....Then select Row and move&qu ✓ - Forum - Excel
- Cascading combo boxes excel vba userform - Guide
- Spellnumber in rupees in excel 2007 ✓ - Forum - Office Software
- Spell number in excel 2007 indian rupees software download - Forum - Office Software
- How to take screenshot in excel 2007 - Guide
1 reply
rizvisa1
Apr 28, 2010 at 08:32 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Apr 28, 2010 at 08:32 AM
You have to set the active printer as for example
Application.ActivePrinter = "PDF995 on Ne00:"
Application.ActivePrinter = "PDF995 on Ne00:"
Apr 28, 2010 at 09:02 AM
Application.Dialogs(xlDialogPrint).Show
Apr 28, 2010 at 09:21 AM