ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing problems (https://www.excelbanter.com/excel-programming/290264-printing-problems.html)

William Maka

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


All times are GMT +1. The time now is 03:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com