why hyperlink not working on Excel?

[Chheda]

Using Excel 2000 (under Windows XP) I cannot get a hyperlink of the formProgramXYZ.exe FileToOpen.ext to work. It fails with the rather unhelpful message "An unexpected error has occurred."

I've tried several simple examples, such as:
notepad.exe C:\Test.txt
or
C:\windows notepad.exe C:\Test.txt
but all fail.
They work fine as normal shortcuts or in the Run box. Anyone have any insights into this please? Or how to work around it?

[Erakna]

Sub Macro1()
x = Shell("cmd.exe /c C:\temp\x.txt", 1)
End Sub

this works assuming the default app for .txt is NotePad

[Chheda]

Thanks a lot for prompt replies of yours. But I'm VERY rusty on this - years since I wrote any Excel macros. After copying that to the clipboard and opening Tools > Macro >Visual Basic Editor, do I just paste that into the empty Personal.XLS that appears? If so, then what?

[Bontu]

Now go to Tools>Macro>Macros and select Personal.XLS!Macro1. if you didn't change the name of the macro then press Run. Also you could create a button to execute the macro.

[Essien]

Looking at the situation I am suggesting that you should launch the Windows explorer and locate a file a manually. Now you should browse for the exact path which you have mentioned into the Link. You should double check the capitalization differences so that traverse the path. If you are able to get the spreadsheet manually and after that you have to see that the sheet name is same as mentioned in path.