using vb to select which printer to use

H

HCS

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
 
F

Frank stone

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing out via vb and selecting the printer 1
Print specific range but user to select printer 4
Directing the Printing using a Macro 2
Print All Sheets-Select Printer First 3
Windows 10 Windows 10 can't find scanner (part of an multi-function printer) 6
List print quality options for defalut printer 5
Select cells in 2 sheets to print in one instance 4
NetWork Printer Selection Problems 1

Top