Automatically choosing a printer to use
 

I have an application where multiple users will be using but I want to
automatically choose their PDF printer (with no input from the user). Is
there VBA code that allows you to pull up the names of the available
printers? Then I can choose the one with PDF in the name.


--
Joe D

Automatically choosing a printer to use
 

Dear Joe

Using CutePDF writer it would be....

Sub Macro ()
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"CutePDF Writer on CPW2:", PrintToFile:=True, Collate:=True,
PrToFileName:="C:\Test.pdf"
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Joe D" wrote:

I have an application where multiple users will be using but I want to
automatically choose their PDF printer (with no input from the user). Is
there VBA code that allows you to pull up the names of the available
printers? Then I can choose the one with PDF in the name.


--
Joe D