Hello All!
I was wondering if any one had a code to print out all .pdf files in a directory like a batch printing process.
I have a code that works for Excel files but not sure how to modify for .pdf
I am open to a new code or if someone can help me modify the one below.
Thank you in advance
Please Login or Register to view this content.
Hello kalyan46,
This macro will print out all of the PDF files in a given folder. You can interrupt the printing by pressing the CTRL+Break keys. If you have any problems with the code, let me know.
Copy and paste the code below into a VBA Module in your workbook.
Please Login or Register to view this content.
Last edited by Leith Ross; 08-28-2018 at 06:11 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
This initially worked fine.. Now for some reason Microsoft Edge is trying to be the default reader and causing an error. I have to go back into default settings and select Adobe as the default which will then run the code.
Is there a way to specify Adobe as the reader or make it work with Edge or make it work with either reader?
Thank you for your assistance!
Hello kaiyan46,
This amended version of the macro opens Acrobat Reader locally on your computer and then prints the PDF file. Let me know if you have any problems.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks