[MS_AccessPros] Retrive AcroRd32.exe location

 

    

Good Day!

How do I retrieve the location of AcroRd32.exe file?

Need location to use it to print multiple PDF files via command.

'strAppPDF= (......AcroRd32.exe)

'!ScanDocPath= (PDF file name)

'strPrinter= (Printer)

'(Prints multiple PDF files via recordset)

..................................................

strSQL = "SELECT * FROM qryEODReportsPDFFiles Where ScanDocDate=#" & Me.txtEODFOLDER & "#"
Set rstRS = dbsDB.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges)

With rstRS
  .MoveFirst
  Do While Not .EOF

     Call Shell(Chr(34) & strAppPDF & Chr(34) & " /P /h /t " & Chr(34) & !ScanDocPath & Chr(34) & strPrinter, 0)

     KillAdobe
     strPrinter = ""
     .MoveNext.

 Loop

End With

..............................................

Thanks

Norbert

__._,_.___

---

Posted by: drnorbert@msn.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___