Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Hyperlink to url returns error: cannot open the specified file

I've converted a column of URLs to hyperlinks using the suggestion at
http://www.microsoft.com/office/comm...=en-us&m=1&p=1
but now when I click on any of the cells containing the hyperlink to the URL,
I just get an error message which says: Cannot open the specified file.
What am I doing wrong?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Hyperlink to url returns error: cannot open the specified file

It's possible that the URLs in your column contain some characters that are causing the hyperlink to malfunction. Here are some steps you can take to troubleshoot the issue:
  1. Check the URLs: Double-check that the URLs in your column are correct and complete. Make sure there are no typos or missing characters.
  2. Remove any spaces: If there are any spaces before or after the URLs in your column, remove them. Spaces can cause the hyperlink to malfunction.
  3. Check for special characters: Check if there are any special characters in the URLs, such as "&" or "#". These characters can cause the hyperlink to malfunction. If you find any special characters, try removing them and see if the hyperlink works.
  4. Try a different browser: If the hyperlink still doesn't work, try opening the URL in a different browser. Sometimes, certain browsers may not be able to open certain URLs.
  5. Check your security settings: If you're still having trouble opening the hyperlink, check your security settings. Your security settings may be preventing you from opening the URL. Try adjusting your security settings and see if that helps.
  6. Use the HYPERLINK function: Instead of using the method you found online, try using the HYPERLINK function in Excel to create your hyperlinks. Here's how:
    1. Select the cell where you want to create the hyperlink.
    2. Type "=HYPERLINK(" followed by the URL in quotation marks.
    3. Close the parentheses and press Enter.

    This should create a clickable hyperlink in the cell that should work properly.

I hope these steps help you resolve the issue with your hyperlinks. Let me know if you have any questions or if there's anything else I can help you with!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Hyperlink to url returns error: cannot open the specified file



"browniebodrum" wrote:

PS When I hover my mouse over the cell with the malfunctioning hyperlink, I
can see that the hyperlink is prefixed with the address on my hard drive of
the directory in which the spreadsheet is saved, whereas if I type in a new
url in a different cell, the link is correct and works. But I don't want to
have to type in all the urls again...
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Hyperlink to url returns error: cannot open the specified file

What was in the cell before you started?

If you look at the hyperlink (Insert|Hyperlink), what is the address do you see?

I'm wondering if you're missing the "Http://" (or mailto: or file:////)
portion????

browniebodrum wrote:

I've converted a column of URLs to hyperlinks using the suggestion at
http://www.microsoft.com/office/comm...=en-us&m=1&p=1
but now when I click on any of the cells containing the hyperlink to the URL,
I just get an error message which says: Cannot open the specified file.
What am I doing wrong?


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Hyperlink to url returns error: cannot open the specified file

Option Explicit
Sub testme()

Dim myRng As Range
Dim myCell As Range

With ActiveSheet
Set myRng = .Range("a1", .Cells(.Rows.Count, "A").End(xlUp))
End With

'delete existing hyperlinks in column A
myRng.Hyperlinks.Delete

For Each myCell In myRng.Cells
myCell.Hyperlinks.Add Anchor:=myCell, _
Address:="File:////" & myCell.Value, _
TextToDisplay:=myCell.Value
Next myCell
End Sub

I like to use the =hyperlink() worksheet function.

I'd put this in B1 (with the first filename in A1):
=hyperlink("file:////"&a1,"Click me!")
and drag down

I find the worksheet function easier to use and better behaved.

If you want to use this, but delete all the existing Insert|Hyperlinks versions,
you can do this:

Select the cells with the hyperlinks to delete
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
selection.hyperlinks.delete

And back to excel to see if they're gone.

browniebodrum wrote:

"browniebodrum" wrote:

PS When I hover my mouse over the cell with the malfunctioning hyperlink, I
can see that the hyperlink is prefixed with the address on my hard drive of
the directory in which the spreadsheet is saved, whereas if I type in a new
url in a different cell, the link is correct and works. But I don't want to
have to type in all the urls again...


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Hyperlink to url returns error: cannot open the specified file

The cell contents originally were simply the url beginning with www. etc
I've put your VB routine in and run that, and now when I hover over the cell
the link begins with file:///\\www. etc whereas with the previously suggested
VB script, the link began with c:/// etc

I don't know anything about VB so I daren't fiddle with what you told me to
cut and paste.

I haven't yet tried using the worksheet function, I'll try that now.
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Hyperlink to url returns error: cannot open the specified file

Figured it out now, plucked up courage to change part of the script that was
causing the problem from 'file:////' to 'http://'and now it works fine, and
launches the browser, thanks!
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Hyperlink to url returns error: cannot open the specified file

I am trying to have a hyperlink open a pdf file on my local machine for quick
viewing. I can't get it to work with PDFs that I have created with Adobe
acrobat or with my document scanner. I use the hyperlink wizard to set up
the link and when I try to click on the link I get the message "cannot open
the specified file"

I tried your "click me" routine and got the same message

Thanks for any advise that you can give me.


"Dave Peterson" wrote:

Option Explicit
Sub testme()

Dim myRng As Range
Dim myCell As Range

With ActiveSheet
Set myRng = .Range("a1", .Cells(.Rows.Count, "A").End(xlUp))
End With

'delete existing hyperlinks in column A
myRng.Hyperlinks.Delete

For Each myCell In myRng.Cells
myCell.Hyperlinks.Add Anchor:=myCell, _
Address:="File:////" & myCell.Value, _
TextToDisplay:=myCell.Value
Next myCell
End Sub

I like to use the =hyperlink() worksheet function.

I'd put this in B1 (with the first filename in A1):
=hyperlink("file:////"&a1,"Click me!")
and drag down

I find the worksheet function easier to use and better behaved.

If you want to use this, but delete all the existing Insert|Hyperlinks versions,
you can do this:

Select the cells with the hyperlinks to delete
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
selection.hyperlinks.delete

And back to excel to see if they're gone.

browniebodrum wrote:

"browniebodrum" wrote:

PS When I hover my mouse over the cell with the malfunctioning hyperlink, I
can see that the hyperlink is prefixed with the address on my hard drive of
the directory in which the spreadsheet is saved, whereas if I type in a new
url in a different cell, the link is correct and works. But I don't want to
have to type in all the urls again...


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
OFFSET: Returns error when used to a linked file Arturo Excel Worksheet Functions 1 June 4th 07 11:48 PM
Can not open a file from hyperlink set Phuoc Nguyen Hanoi Links and Linking in Excel 0 November 28th 06 05:36 AM
Hyperlink won't open any other XLS file Jinx1966 Excel Discussion (Misc queries) 2 February 9th 06 09:26 AM
file open via IE hyperlink causes already open files to shrink and tile Marc Setting up and Configuration of Excel 0 May 4th 05 08:13 PM
hyperlink error: "Cannot open the specified file" Kate Choi Excel Worksheet Functions 1 January 18th 05 03:38 AM


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"