View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William Maka William Maka is offline
external usenet poster
 
Posts: 2
Default Printing problems

I'm having problem printing to a specific printer (TorIT)
from different locations on our network. Specifically
Ne## (i.e. Ne06) has to be changed for different desktop
location.

How can I change the syntax for all the users to be able
to print on that printer (TorIT) without having to alter
the code for each of them?

VB code below:
Application.ActivePrinter = "\\servername\TorIT on Ne06:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\servername\TorIT on Ne06:", Collate:=True