yep I did that but it seems to still require that the user actually has
that printer locally installed in their profile even though the printer
is on the network so is always available. if they dont have the printer
it comes up with the same error.

is there some way i can get around this so that it WILL print to that
printer regardless of whether they have it installed (or some seamless
way to silently install that printer on their profile)?


--
neowok
------------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=272024

Things I've read (and some experience) indicate that the "on Neo:NN" part at
the end of the Application.ActivePrinter 'name' is critical - based on the
fact that adding a new printer can change that port designator for other
printers and mess up hard-coded Excel printer Application.ActivePrinter
names.

Which is to say, my guess is that a web search on VBA "install printer" is
the path you are going to have to take.

Good luck!

James

"neowok" wrote in message
...

yep I did that but it seems to still require that the user actually has
that printer locally installed in their profile even though the printer
is on the network so is always available. if they dont have the printer
it comes up with the same error.

is there some way i can get around this so that it WILL print to that
printer regardless of whether they have it installed (or some seamless
way to silently install that printer on their profile)?


--
neowok
------------------------------------------------------------------------
neowok's Profile:
http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=272024