VBA code to print 2 external PDF files while working on excel sheet

[Ramadan]

While working on excel worksheet I need to print 2 different external PDF files in the same folder for my clients to sign

here is the files paths "D:\Templates to Print\Acknowledgment.pdf" and "D:\Templates to Print\Works Permit.pdf"

can you please tel me what is the code that I can use to print such files

 

[Ramadan]

I have found this code while searching through internet but unfortumately not working

[sub print_file()
Print_and_Close_PDF "D:\Templates to Print\Acknowledgment.pdf"
End sub]

 

[Joe4]

I have found this code while searching through internet but unfortumately not working

[sub print_file()
Print_and_Close_PDF "D:\Templates to Print\Acknowledgment.pdf"
End sub]

In that code, it looks like "Print_and_Close_PDF" would be a custom procedure or function that is created with VBA code.
Whereever you found that "code", you should dig a little deeper and see in the accompanying code for "Print_and_Close_PDF" is also contained in that posting (or in some Add-In they are using).
You will need to copy and paste that code in your VBA Project is order to call and use it.

 

[Logit]

The following code works here on my two pdf files.
I've inserted the paths to your two files in this macro.

Option Explicit

Sub PrintPDF()
Dim pdfPath As String
Dim pdfPath2 As String
Dim acroPath As String
Dim acroPath2 As String

' Set the path to the FIRST PDF file
pdfPath = "D:\Templates to Print\Acknowledgment.pdf"

' Set the path to Adobe Acrobat Reader (adjust if your path is different)
acroPath = "C:\Program Files\Adobe\Acrobat DC\Acrobat\Acrobat.exe"

' Print the PDF file
Shell """" & acroPath & """ /t """ & pdfPath & """", vbNormalFocus


' Set the path to the SECOND PDF file
pdfPath2 = "D:\Templates to Print\Works Permit.pdf"

' Print the PDF file
Shell """" & acroPath & """ /t """ & pdfPath2 & """", vbNormalFocus

End Sub

You must have Adobe Reader installed. Download here : PDF reader: The original PDF solution | Adobe Acrobat Reader

 

[John_w]

I have found this code while searching through internet but unfortumately not working

[sub print_file()
Print_and_Close_PDF "D:\Templates to Print\Acknowledgment.pdf"
End sub]

That appears to be my code from Excel VBA Open pdf (struggling). Follow all the instructions in that post.

But note that it relies on the default PDF application being able to print from the context menu when you right-click a PDF file in File Explorer.