Hi,
I have set up a macro to automatically save and promt the user to PDF the
worksheet and print on a set printer on the network, it all works well on my
computer but on others computers the links to the printer don't work or
PDFing the file don't work, how do I fix this. An example of the error msg is
Application.ActivePrinter = "Adobe PDF on Ne10:"

Are the other users able to PDF any document using this "printer"? My bet is
they don't have that capability.

"JonathanW" wrote:

Hi,
I have set up a macro to automatically save and promt the user to PDF the
worksheet and print on a set printer on the network, it all works well on my
computer but on others computers the links to the printer don't work or
PDFing the file don't work, how do I fix this. An example of the error msg is
Application.ActivePrinter = "Adobe PDF on Ne10:"

If they are on the same server as you, there should be not problem setting
them up to print on the PDF printer. However, if they are on a different
server, then each workstation that is on the other servers would have to be
individually mapped to a PDF printer. Even if they have the same printer on
their server, the port reference could be different. That's the problem with
using specialized printers on a net. It is best to use standard print as
much as possible so you can just use ActrivePrinter.PrintOut.

"JonathanW" wrote:

Hi,
I have set up a macro to automatically save and promt the user to PDF the
worksheet and print on a set printer on the network, it all works well on my
computer but on others computers the links to the printer don't work or
PDFing the file don't work, how do I fix this. An example of the error msg is
Application.ActivePrinter = "Adobe PDF on Ne10:"