View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default Inserting Hyperlinks

=HYPERLINK("file:///c:/documents and settings/administrator/my
documents/movies/elephant.avi")

Sorry, I now realise why it wouldn't work. I wasn't stating the file format
at the end of the path name. Without .avi it wouldn't work, but with it, it
works fine.

Thank you for your help. It took your example to bring me to my senses.

Andrew



"Gary''s Student" wrote:

Post an example of what you enter and what is is changed to.

This format:

=HYPERLINK("file:///g:/temp/DSC_0002.JPG")


may help.
--
Gary''s Student - gsnu200773


"Andrew" wrote:

I need to insert hyperlinks into excel aiming at movies on my HDD. (Don't
ask, its a favour for someone) Which works fine, until I save and re-open the
excel file. It appears to be because excel shortens the path and therefore
breaks the link.

I have tried the Properties, Summary and Hyperlink base fix but find this
doesn't work for me. The 'Cannot find specified file' error persists.

I have also used =HYPERLINK function with no luck either.

How can I stop exel shortening the path?

Andrew