Printing Marco from different PC's

[I heart Excel]

Hello,

I have a form that is accessed from a central location by many users on differnet PC's, and printed to a Virtual Printer.

The code I currently have is -

Application.ActivePrinter = "\\VirtualPrinter\1234 on Ne02:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"\VirtualPrinter\1234 on Ne02:", Collate:=True

When I ran the Macro from another PC it didn't work. When I re-recorded the Macro on the other PC the 'Ne02' changed to 'Ne06'.

I tried taking out the Ne** so it just read "\\VirtualPrinter\1234", but this didn't work either.

Is there anyway around this?

Thanks