Network printing problem

[LeapingLizard]

Hello all,

I am trying to figure out why this code is not working properly on my bosses computer, but works just fine off of my computer. The file is located on a shared drive, so I am not understanding why. Don't know if anyone has ever experienced this at their work place before, if so, your assistance would be greatly appreciated.

Attached is the VBA I use to print a worksheet. It will ask what printer the user would like to use and the default on both our machines is the same.
It throws a runtime error of 1004 on this line - Application.ActivePrinter = "\\wshps4\ghcolor on Ne03:"
Here goes:

Please Login or Register  to view this content.