Excel 2007 : Hyperlinks Stopped Working in One Sheet of a Worksheet - "Cannot Open the Specified File"

I created a macro to open PDF's via a right-click event using Application.FollowHyperlink in an Excel 2007 worksheet. It worked fine on my PC which has Adobe reader 9 installed. But my co-workeds, using Adobe X, got an error which produced two error messages and locked up Excel for 5-10 minutes before finally opening the PDF. I found a bunch of different suggestions online but this simple solution by David Crake worked perfectly for me...

===================================================================
Application.FollowHyperlink doesnt work


Place the following into a standard module

Code:

Please Login or Register  to view this content.

Then in your form place the following code on the double click event of the control


Code:

Please Login or Register  to view this content.

Where StrDefaultPathAndFileName is the full path and file name that you want to open.

This works for any type of file and opens the nominated file in its native software.
_________________
David Crake

============================================

nlexcel,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.