|You can use something like this, this code uses ShellExecute to open the file within your hyperlink|
In this case it is refering to Range("A1") only, this is where you hyperlink needs to be, when you run the code from 'Sub Start' it will check if the file exists, then open the file if it does, or do nothing if it doesnt.
If you can explain how you want the code to function i/we can modify to suite, it if a try and see if it helps.
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
(ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _
ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Dim FileName As String
FileName = Range("A1")
If FileExists(FileName) Then
ShellExecute 0, "Open", FileName, "", "", vbNormalNoFocus
Private Function FileExists(sFile As String) As Boolean
If Dir(sFile) <> "" Then
FileExists = True
FileExists = False