Print PDF file (VBA)

[Novice1]

I have a pdf file which I want to print (Event Procedure on button). I'm having trouble finding how to print the file. Any suggestions would be helpful

 

[The_Doc_Man]

I would presume that the file to which you refer already exists, because it is possible open a report from VBA code in a mode that prints it (to the default printer) automatically.

In this case, look up articles on how to use the File System Object (FSO), after which it would be possible for you to just select that file by name assigned to an object variable, then use a .Print method on it.

 

[sneuberg]

I suggest watching this video which shows how to display a PDF file in Web Browser control. You can right click on the displayed PDF to print it.