Automatically choosing a printer to use

[Joe D]

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.

 

[Jacob Skaria]

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]

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