LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default How do you change the default printer?

I would like to from within Excel as an VBA instruction change the
name of the default printer, just as if I went to the Windows Control
Panel and did it. Incorporating in my code either of the instructions
Application.Dialogs(xlDialogPrint).Show or
Application.Dialogs(xlDialogPrinterSetup).Show
lets me change the printer for that job, but seems to leave the
name of the default printer the same as before. Any suggestions,
anyone?

-- Dennis Eisen
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default settings for my printer in Excel change when Import workbo rickitoni Excel Discussion (Misc queries) 1 February 7th 09 06:46 PM
Default Printer aftamath77 Excel Discussion (Misc queries) 2 November 26th 08 05:37 PM
members on my network printer not able to print to default printer smeheut Excel Discussion (Misc queries) 0 June 18th 07 06:42 PM
How do I change default printer settings Vanessa Setting up and Configuration of Excel 2 September 3rd 06 12:16 AM
excel macro to automatically change default printer James Bromley Excel Discussion (Misc queries) 1 January 15th 06 11:42 AM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"