i want to print existing pdf particular page based on employee id and save that id and print date in database .i somehow got the code to open and print whole pdf file.kindly help me to pass an argument to pdf file which opens and print that page only.
thanks in advance
thanks in advance
Code:
Sub testpdfprint()
Print_PDF ("C:\letter.pdf") 'Put your PDF in here
End Sub
Sub Print_PDF(sDocumentFullPath As String)
Dim sAcrobatReaderExe As String ' full path to the Acrobat reader executable
sAcrobatReaderExe = "C:\Program Files (x86)\Adobe\Reader 11.0\Reader\AcroRd32.exe" 'Change this to where AcroRd32.exe is on your machine
RetVal = Shell(sAcrobatReaderExe & " /P " & Chr(34) & sDocumentFullPath & Chr(34), 0)
End Sub
Comment