Macros / using on other computers

J

JonathanW

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:"
 
B

Barb Reinhardt

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

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top