Printer Settings do not change

  • Thread starter Thread starter dauschi
  • Start date Start date
D

dauschi

Hi there!

This is my first post here so i'd like to say *HELLO* from sunn
Germany at first :)

So this is my problem:
We have a printer that is installed on our printserver with tw
different drivers..... one with plain paper (Tray 2) and one wit
pre-printed paper (Tray 3).
When i assign the Tray2 printerdriver as the default printer in window
and try printing out of Excel everything is fine.
But when i change the printer within Excel the "new" settings (Tray
instead of Tray2) are NOT being applied by MS Excel - i am forced t
change it manually.
Nonetheless this problem only occurs within Excel....Word or any othe
program do apply the changes from the "new" printer.... :confused:

does anyone know a workaround for this feature? any help would b
greatly appreciated!!

Kind Regards,
Simo
 
Presumably you are using something like this ... ?

'--------------------------------------------------
Dim MyPrinter As String
MyPrinter = "\\CTLU-LU0-PR01\'Dandy' Ground Floor Middle Equipmen
Pod on Ne00:"

ActiveSheet.PrintOut ActivePrinter:=MyPrinter
'-------------------------------------------------------
 
no sorry do disappoint you....i just select the printer by clickin
"File - Print" and so on......

isn't there a way to resolve it without using macros and stuff?

simo
 
Hi Simon,
Open printers and create a copy of the installed printer.
You will have something like... hplaser & hplaser(1)
Change the default tray in one copy to tray 2 and the other to tray 3.

To use a different tray just change "printers"
Of course you can rename them so you know which is tray2 & ...




--
John
johnf 202 at hotmail dot com


| no sorry do disappoint you....i just select the printer by clicking
| "File - Print" and so on......
|
| isn't there a way to resolve it without using macros and stuff?
|
| simon
|
|
| ---
| Message posted
|
 
Back
Top