Linking to a .pdf file? 1

[mrdod]

When I click the button to activate my code I get a flash then it goes away. Why can't I get the file to stay open? Are there settings that need to be modified? Anyway here is my code. Any help would be great.

Application.FollowHyperlink "C:\Documents and Settings\myname\My Documents\Bonerite 1070.pdf", , True, True


Thanks

 

[jrbarnett]

Which PDF reading software are you using?

Does the file open normally (ie if you open it from File -> Open or double click it in Windows explorer)?

Have you tried the FAQ here on using ShellExecute to run it instead, which runs the equivalent of double clicking it in Windows Explorer?

John

 

[mrdod]

Thanks for the reply.

I'm using Adobe Acrobat 7.0 and yes it opens fine when I dbl click it in Windows. I can't seem to find the FAQ you are referring to. I will keep searching.

Thanks you

 

[mrdod]

I've been trying this from home and after looking on the internet a while I found some code (below). The problem is after clicking the button nothing happens...Nothing. What am I missing besides a brain???

Private Sub Command0_Click()
Dim stappname As String
stappname = "C:\Documents and Settings\Person\Linksys_BEFW11S4_Wireless_4_Port_CableDSL_Router_Manual.pdf"
ShellExecute 0, "Open", stappname, "", "", conShow
End Sub

Again any help would be great!!

Thanks

 

[jrbarnett]

faq705-2299 or

http://www.vbaccelerator.com/codelib/shell/shellex.htm

to name but two.

Unless you have put the ShellExecute function in your database, this will be where it falls over.

John

 

[mrdod]

Thanks John I finally got a chance to look into this using the links provided and got it to work. I appreciate your help.