ExcelBanter - Change Printers in VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Change Printers in VBA (https://www.excelbanter.com/excel-programming/315463-change-printers-vba.html)

Bill Agee

Change Printers in VBA

I would like to be able to display a combo/drop down with all of the
available
printers on my system and select the printer of my choice at any time from
my Excel program.

Is this possible? Is this something avaialble within Excel?

Any suggestions?

Ron de Bruin

Change Printers in VBA

Hi bill

You can use this
Application.Dialogs(xlDialogPrint).Show

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Bill Agee" wrote in message link.net...
I would like to be able to display a combo/drop down with all of the
available
printers on my system and select the printer of my choice at any time from
my Excel program.

Is this possible? Is this something avaialble within Excel?

Any suggestions?

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