Hyperlink pdf problem

[Darrell Lankford]

We have an excel file with a listbox were we pick from a list of pdf
files and the code will open the selected pdf file. It works fine on
everybody's system except one. We have one guy whose computer bit the
dust and was replaced and this file crashes.
After selecting the pdf file from the list I get the following message:

*************************
Opening\\................pdf

Some files can contain viruses or otherwise be harmful to your
computer.
It is important to be certain that this file is from a trustworthy
source.

Would you like to open this file?
***************************
When I select okay or cancel, it crashes at
"ActiveWorkbook.FollowHyperlink Address:=mylink" of the following code:

Private Sub CommandButton1_Click()
If ListBox1.Value = "" Then Exit Sub
mylink = cVersion & "\" & ListBox1.Value
ActiveWorkbook.FollowHyperlink Address:=mylink
Unload Me

End Sub

I tried putting a hyperlink directly in the file and I get the same
message as stated before and then I get the message:

******************
No program is registered to open this file
******************

Adobe Reader 7.0 is installed on the system, but I have no idea why
it's crashing on this system.

Any assistance would be greatly appreciated.

 

[NickHK]

Darrell,
What is the value of "mylink" ?
Is it all such hyperlinks or only PDF files ?
I assume Reader is working correctly ?
Did you try a re-install of Reader ?

NickHK

 

[Darrell Lankford]

Nick,

Our IT Department reinstalled Acrobat Reader and installed an update
and it's working fine.
Thanks for the help,

Darrell