How to Print a PDF in Excel VBA?

[jacksa2]

Hello All,

I've been working on being able to print a PDF file from Excel VBA but having a rough time with it. Every example I can find is very different than the next and none have worked.

Concept is fairly straight forward.
-User inputs file name.
-Look for PDF with that name in specified folder
-Print it
-Close PDF viewer if it opens

I have already made code that works for word and excel file types, but cant figure out PDF.
I am working with Excel 2010 on windows 7, with Adobe reader 11.0 in the standard C:\Program Files (x86)\Adobe\Reader 11.0 location.

Any help would be greatly appreciated! Thanks

 

[starl]

This is a really old post and not one with code I use much.
No, you can't specify a page - ShellExecute doesn't allow you to set parameters like that when using the PRINT command.
As for closing the file - you would have to find and Kill the process (Adobe). There is code out there for that, but I am not comfortable posting such code that interferes with the OS (especially untested)

 

[BaturFurkan]

This is a really old post and not one with code I use much.
No, you can't specify a page - ShellExecute doesn't allow you to set parameters like that when using the PRINT command.
As for closing the file - you would have to find and Kill the process (Adobe). There is code out there for that, but I am not comfortable posting such code that interferes with the OS (especially untested)

Thank you very much for your explanation. Instead of printing pdf, I just want to open the pdf file. What changes should I make in the code?

 

[starl]

In the ShellExecute call change the "Print" to "Open"

 

[Adul_C]

In the ShellExecute call change the "Print" to "Open"

Hi Starl
is it possible to specific save folder in order to bypass the prompt popup screen ask for save file?
Thank you in advance.

 

[starl]

I don't know. As stated earlier, I don't use ShellExecute very much.
You might have better luck if you posted a new question - it will be more prominent and others may look at it.