Urgent: need help w/ Application.activeprinter in Novell environment

[innov]

Hello all.

I've got an Excel VBA app that's worked fine for years but now IN A NOVELL SHOP, I'm getting a 1004 method failed error with the Application.ActivePrinter = default_printer (default_printer being the string holding the default).

The app uses the Application.ActivePrinter method to: (1) change the active printer / driver to a user-defined destination (including PDFwriter); and (2) change the active printer back to the default when done (I capture the default before changing the active printer).

Strange thing is, the activeprinter does seem to be changing after the error, but I don't want to simply ignore the error because there may be a legitimate issue. (by the way, I hate the generic 1004 run-time error).

Has anyone dealt with this in a Novel environment before? FYI - I'm looking for code that will work with and without a Novell network.

THANKS IN ADVANCE!

innov

 

[dyarwood]

Have you got anything like

MsgBox(Application.ActivePrinter)

before the line but comment it out when it comes to deployment. Then you can get the exact statement to select the printer you need.