Print pdf in folder on pc

[ipbr21054]

Hi,

I have a YES / NO message box code in use as shown below.

I need to add a code for when i select NO as opposed the current EXIT SUB

My invoice is taken from worksheet INV & in cell L4 is the invoice number
The pdf is saved like so 123.pdf
The folder path for where it is saved is C:\Users\Ian\Desktop\REMOTES ETC\DR\DR COPY INVOICES

My goal is when a user selects NO the code should print the invoice in question so this example is 123.pdf from path supplied.
If its not possible then just open the pdf so i manually the select print

Thanks

   answer = MsgBox("INVOICE HAS NOW BEEN SAVED" & vbNewLine & vbNewLine & "DID THE INVOICE PRINT OK FOR YOU ?", vbInformation + vbYesNo, "INVOICE PRINT OK MESSAGE")
    If answer = vbNo Then
    Exit Sub
    Else

 

[ipbr21054]

I have managed this so far.
My question is,
When it prints will it print whats on the excell page or the pdf file ?
Im expecting it to be the pdf file
Please advise.

      answer = MsgBox("INVOICE HAS NOW BEEN SAVED" & vbNewLine & vbNewLine & "DID THE INVOICE PRINT OK FOR YOU ?", vbInformation + vbYesNo, "INVOICE PRINT OK MESSAGE")
    If answer = vbNo Then
    VBA.Shell "explorer.exe /select, " & "" & strFileName & "", vbNormalFocus
    .PrintOut copies:=1