View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
browniebodrum browniebodrum is offline
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.