Open An Adobe PDF File For Viewing From Access VBA

[dorlesky]

I'm looking to find a solution to opening an Adbobe PDF file "Read-Only" from an Access 2003 form with VBA code.

I am using a text box to supply the file path and name, and a table that stores all the file path's and names relating to the documents needed.

I would like to stay away from Hyperlinking if possible.

Thanks for reading &/or helping with this....

 

[genomon]

Public Sub OpenDocument(strDocPath As String)

Dim G As Long
G = Shell("RUNDLL32.EXE URL.DLL,FileProtocolHandler " & strDocPath, vbNormalFocus)
    
End Sub

Where strDocPath is, amazingly, the path of the document you wish to open. Also works for any file extension your PC supports (.doc, .wav, etc.).

Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes.

 

[dorlesky]

Thanks so much.

Stellar!!!! Works Slick....

 

[HughLerwill]

A little chat I had with myself recently in thread222-1410995 may also be of interest.

 

[palz]

Thanks a lot!