Print a PDF document from Userform Command Button

HI,

I have a userform from which I need to be able to print a PDF document when the command button is pressed.

User enters the document number in docnum textbox (eg. 123)

On pressing the commandbutton printdoc, I need to be able to print document 123.PDF to default printer

All PDF Documents reside in a network folder mapped to the S:\PDF\drive.

If the document is not found I need to display an error message stating this and return focus back to the textbox.

If the document is found I need to display a message stating document sent to printer.

Is this possible?

Any help appreciated

Your UserForm does not have a Commandbutton.

It would be beter to have a combobox list the avilable files then the combobox change event could print the selected file

What code do you have? You just place it in the Commandbutton_Click event, double click on the butto in the VB Editor

OKay - I have that solved now. I didn't have the module loaded

I have one more question please:

I am using shell execute to print a PDF file. The PDF filename changes based on the value of a text box. For example:

User types 123 in a text box

On clicking the command button, shellexecute runs and opens file c:\MOT\123.PDF
How do I code the filename using the input from the text box?

Private Sub PRINTCERT_Click()
  Dim RetVal As Long
  On Error Resume Next
  RetVal = ShellExecute(0, "open", "C:\Mot\xxx.pdf", "<arguments>", "<run in folder>", SW_HIDE)
End Sub

[/COLOR]Any help appreciated

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Where's the textbox & hat type have you used?