Hyperlink files same folder only?

[dahljam]

I want to create an Excel index to pdf files in a folder usin
hyperlinks. I want to be able to share with others who do not have th
same directory structure, but who simply create a folder of some name
and fill it with the set of pdf files and the Excel index file.

I thought this would be easy, if I just enter the file name
only(stripping any path information). But this doesn't seem to work.
I wonder if there is some prefix to a file name that will present Exce
from inserting a path name in front of it; or some internal Exce
setting that controls this.

Basicly the hyperlink index works on my system, but won't work in th
folder of the recipient whom I emailed it to. And if I fix it ove
there and email it back to me, then it won't work on my system.

I tried using quotes; typing "FILE:abc.pdf", and enterin
"./abc.pdf",etc.

Also we have generally left menu item "File > properties > hyperlin
base" =blank.

Any thoughts will be appreciated.

Jim

 

[Dave Peterson]

How about using the =hyperlink() worksheet formula and a helper cell where they
can type in the full path:

With the name of the file in A2:Axx and the path in A1 (including the rightmost
backslash), you could put this in B2:

=hyperlink("file:////" & $a$1 & a2,"Click me")
and drag down.

You'll have to make the users understand how to change A1, though.

 

[Bob I]

You need to Turn Off "Update Links on Save" You will find that in Tools
Options, General, Web Options, Files.
Also using the Auto Open macro below in the workbook will prevent the
undesired updates from "breaking" the portability.

Sub Auto_Open()
'
' Auto_Open Macro
'
'
Application.DefaultWebOptions.UpdateLinksOnSave = False

End Sub

 

[nagilum]

Hello all,

It is possible to create a hyperlink that is linked only to the files that are in folder of the excel sheet. This is very helpful if you want to create a spreadsheet with links to files that you want to send to others

just use the formula =HYPERLINK("..\folder name\filename.extension","MyName")
Folder name should be the folder where the exel file is

Hope this will be helpful for other people because I spent 2 hours googling for it and I couldn't find an answer and it was so simple...