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/

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/