ACCESS FEED: Re: [MS_AccessPros] Retrive AcroRd32.exe location

Minggu, 12 April 2015

Re: [MS_AccessPros] Retrive AcroRd32.exe location

Good question. In Windows, it's normally in Program Files\Adobe\Acrobat Reader DC\Reader

In some older versions, it might be in Program Files\Adobe\Acrobat\Reader .. or some slight variation thereof. You could try using Dir starting at C:\Program Files\Adobe and then walk down the tree until you find it.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Apr 12, 2015, at 5:03 PM, drnorbert@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

Reply via web post

•