active printer

[Gixxer_J_97]

hi all,

i have a project that will be using two different printers when printing
documents. one will handle envelopes and the other printer will handle
everything else.

my problem is that the printers are not 'named' the same

ie on computer 1 the printer for envelopes is named:
\\server\printer name 1 on Ne03:

on computer 2 it is
\\server\printer name 1 on Ne02:

how can i code my printout sub so that it will use the correct name?

(i haven't tried yet but can i set activeprinter = \\server\sharename ?)

tia

J

 

[Bob Phillips]

why not use the print dialog and allow selection

application.dialogs(xlDialogPrint).Show

 

[keepITcool]

you'll find some examples:

http://groups-beta.google.com/groups?q=printerfind+keepitcool

or try to get the next thing on 1 line..
http://groups-beta.google.com/group/microsoft.public.excel.programming/m
sg/8bd61fe9b777be6f


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Gixxer_J_97 wrote :