PDF Print

[quickc2]

Hi,

I am looking to create a macro that, when ran, will print a pdf version of the excel sheet, as well as a pdf that is saved in a different folder.

Sub PrintPdf()
Dim Pth As String
Pth = """\projects\Projectsin Progress\VIN\4 People\217630.pdf"" "
Dim fullCommand As String
fullCommand = """C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe"" /t " & Pth

Shell fullCommand

End Sub

That is what I had from before that seemed to be working. But it is not properly printing the pdf that is saved in a different folder. I checked and made sure that everything still had the same name. Not sure what is erroring out.

Any other ideas on how to accomplish this task?

 

[Dan_W]

On what line does the error appear, and what does the error say?