ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   using vb to select which printer to use (https://www.excelbanter.com/excel-programming/314238-using-vbulletin-select-printer-use.html)

HCS

using vb to select which printer to use
 
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



Frank Stone

using vb to select which printer to use
 
hi
this is from my network. i don't know how your's is set up
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\OKI-01\OKI-HP4000-01 on Ne01:", Collate:=True
regards
Frank

-----Original 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:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com