Hyperlink to Current Folder
Louis was wondering if it’s “possible to make a hyperlink in Excel that will always link to the folder in which the file is presently saved”? I had a free minute to give it a whirl and it looks like it’s indeed possible:
To get the location of the folder your spreadsheet is in try this:
Then just add a basic hyperlink, substituting the location with the previous formula:
=HYPERLINK(MID(CELL("filename"),1, FIND("[",CELL("filename"))-1),"Current Folder")
Viola! You now have a hyperlink in your worksheet, that when clicked will open the current folder (reminds me of the vba open dialog box).
Note: The second example has a line break in it. If you are copying and pasting, make sure that formula is all on 1 line.