Hyperlink to Current Folder

hyperlink to current folderLouis 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:

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.

ADS GO HERE

Posted in

Leave a Comment