macro for printing to nondefault printer

[McStevens]

I can't get my macro to work where I set the active printer to a printer name. It doesn't recognize the network printer even though I used the exact printer name. If I record a macro where I select the network printer it works fine on that workstation but if I use it from another workstation it can't find the network printer even though that workstation can see that printer and can print to it. Any suggestions?
Peter
This message was edited by McStevens on 2002-04-24 14:36

 

[Legacy 98055]

Post your code Peter
This message was edited by TsTom on 2002-04-24 09:57

 

[McStevens]

I've tried it 2 ways:

1st
ActiveSheet.PrintOut ActivePrinter:="Office2"

2nd
xOriginalPrinter = Application.ActivePrinter
Application.ActivePrinter = "Office2"
ActiveSheet.PrintOut
Application.ActivePrinter = xOriginalPrinter

both of these follow some other code doing calculations.
Pete