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?

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!

"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...

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

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

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.

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!

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