default printer
hello,
does anybody know how to select the default printer installed in windows as the activeprinter? application.activeprinter = (defaultprinter) This must be written in a macro Regards, Niek ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
default printer
I don't think there is a default printer option
But you can change the activeprinter to the printer you want Application.ActivePrinter = "hp officejet k series on Ne00:" To know the names of your pinters Change to it in the ctrl P dialog (Cancel after choose the printer ) and run this so you know the name Sub nameprinter() MsgBox Application.ActivePrinter End Sub If you print with code then look at Printout in the VBA help You can fill in the name of the printer -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "solo_razor" wrote in message ... hello, does anybody know how to select the default printer installed in windows as the activeprinter? application.activeprinter = (defaultprinter) This must be written in a macro Regards, Niek ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 08:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com