Nokia C3: why hyperlink not working on Excel?

why hyperlink not working on Excel?
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?
Reply With Quote
#2
Old 04-01-2012
Erakna Erakna is offline
Member

Join Date: Mar 2011
Posts: 507
Re: why hyperlink not working on Excel?
Code:

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

this works assuming the default app for .txt is NotePad
Reply With Quote
#3
Old 04-01-2012
Chheda Chheda is offline
Member

Join Date: Nov 2011
Posts: 60
Re: why hyperlink not working on Excel?
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?
Reply With Quote
#4
Old 04-01-2012
Bontu Bontu is offline
Member

Join Date: May 2011
Posts: 500
Re: why hyperlink not working on Excel?
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.
Reply With Quote
#5
Old 04-01-2012
Essien Essien is offline
Member

Join Date: May 2011
Posts: 414
Re: why hyperlink not working on Excel?
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.
Reply With Quote