Run time error.
Posted by Bob T on August 29, 2001 5:50 AM
I would like my macro to select a specific printer from the network. 90% of the users are able to use this macro just fine. However, the other 10% of the users receive a run time error 1004 (Method Active printer of object_ Application failed) message.
The start of my macro reads:
Application.ActivePrinter = "\\usps002\PRT188 on Ne01:"
Selection.PrintOut Copies:=1, Collate:=True
Do you have any suggestions? Is it a network or Window 2000 issue or can you help me on the code. I cannot have this printer as the default printer. However, if this file could be set up to print to that specific printer would be another solution. Is there a way to do this instead? I would really appreciate your help.