Thread: active printer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gixxer_J_97[_2_] Gixxer_J_97[_2_] is offline
external usenet poster
 
Posts: 206
Default active printer

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