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

why not use the print dialog and allow selection

application.dialogs(xlDialogPrint).Show

--
HTH

Bob Phillips

"Gixxer_J_97" wrote in message
...
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

you'll find some examples:

http://groups-beta.google.com/groups...ind+keepitcool

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


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


Gixxer_J_97 wrote :

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