Results 1 to 5 of 5

Thread: why hyperlink not working on Excel?

  1. #1
    Join Date
    Nov 2011
    Posts
    60

    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?

  2. #2
    Join Date
    Mar 2011
    Posts
    542

    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

  3. #3
    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?

  4. #4
    Join Date
    May 2011
    Posts
    523

    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.

  5. #5
    Join Date
    May 2011
    Posts
    410

    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.

Similar Threads

  1. Hyperlink not working in Excel 2007
    By Technocrat52 in forum Windows Software
    Replies: 4
    Last Post: 28-03-2012, 11:54 AM
  2. Automatic Filter on Hyperlink in Excel
    By Mike Chester in forum Software Development
    Replies: 2
    Last Post: 17-03-2012, 12:06 PM
  3. Want to hyperlink only one word in a cell of Excel
    By Iyyappan in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 06:54 PM
  4. Replies: 3
    Last Post: 01-02-2012, 07:15 PM
  5. Macro for hyperlink on Word/Excel
    By Mindstorm in forum Windows Software
    Replies: 3
    Last Post: 07-05-2009, 02:43 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,637,990,550.37320 seconds with 17 queries