Install Printer with VBA

Question

3.00/5 (1 vote)

See more:

Good day all,

I could really use some help with this. I need to install a printer via VBA. The port will be a Local Port with the name of C:\My Documents for example. It will have a printer name of PS1. This will use a PS printer driver that is available to the user.

I've searched all over and i am getting frustrated. The closest thing that i saw that might do the trick as the AddPortEx API, but i just dont know how to start.

Thanks for any info.

UPDATE:
I am still doing some research and found that this could be done by using a batch script. Seems like the string would look something like this:

rundll32 printui.dll,PrintUIEntry /if /b "Test Printer" /c\\SERVER /f "%windir%\inf\ntprint.inf" /r "lpt1:" /m "AGFA-AccuSet v52.3"

How could i incorportate my requirements to this?

Port Name: C:\My Documents
Printer Name: PS1
Printer Driver: PS Printer

Thanks for your help.

Posted 6-Jan-12 19:53pm

emrtnz

Updated 7-Jan-12 11:52am

v2

Add a Solution

Comments

Maciej Los 11-Jan-12 16:32pm

Why VBA?

emrtnz 17-Jan-12 13:54pm

hi losmac,

I'm working within an Office product, MS Project 2007. I am passing some variables through the code, such as the port name. I cannot place a folder at the root. It has to be in My Documents. We have different OSs and ofcourse, each has a unique username as part of the path. This is why i'm doing it in VBA. I can have the code create the folder for the port based on the users path information.

What else would you suggest? If you say batch script, then I would not mind going that route because im sure that i can create a batch script with VBA and then run it from VBA.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2012-01-18T12:04:00

Here[^] (Paul Carmen answer) you'll find a peace of code (working with vba) to remove all network printers and and define one.

Here[^] you'll find an answer how to display "Add printer" dialogbox with vba, using SendKeys function.

Here[^] is the ms social technet site, where you'll find more informations about "add printer"...