ExcelBanter - printing out via vb and selecting the printer

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

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

- - printing out via vb and selecting the printer (https://www.excelbanter.com/excel-programming/314023-printing-out-via-vbulletin-selecting-printer.html)

HCS

printing out via vb and selecting the printer

Hello,
when using the printout command the page simply prints out to the default
printer. how can you use vb to select a printer

cheers

Tom Ogilvy

printing out via vb and selecting the printer

Look at the Application.ActivePrinter method in Excel VBA Help.

--
Regards,
Tom Ogilvy

"HCS" wrote in message
...
Hello,
when using the printout command the page simply prints out to the default
printer. how can you use vb to select a printer

cheers

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