Hyperlink to Current Folder

October 13th, 2005 | Categories: Formulas | Tags: ,
-->

currentfolderLouis 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:

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)

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.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. Jazzer
    October 14th, 2005 at 05:03
    Reply | Quote | #1

    Works with LEFT function also:

    =HYPERLINK(LEFT(CELL(“filename”),FIND(“[“,CELL(“filename”))-1),”current folder”)

    - Asser

  2. mark
    October 14th, 2005 at 11:41
    Reply | Quote | #2

    Thanks jeezer, not sure why I think of mid first.

  3. Ratika
    December 17th, 2005 at 02:30
    Reply | Quote | #3

    Can we hyperlink a certain range of autofiltered data in another worksheet