How To Create A Hyperlink To The Current Workbook Folder

2017-11-18

How-To-Create-A-Hyperlink-To-The-Current-Workbook-Folder How To Create A Hyperlink To The Current Workbook Folder

Example

=HYPERLINK(LEFT(CELL("filename",C2),FIND("[",CELL("filename",C2))-2),"Click Here!")

Generic Formula

=HYPERLINK(LEFT(CELL("filename",AnyCell),FIND("[",CELL("filename",AnyCell))-2),"Text")

  • filename” – This is a predefined Excel parameter input for the CELL function.
  • AnyCell – This can be any cell in any sheet of the workbook.
  • Text – This is the text you want to show instead of the folder path. If left blank the folder path will show in the hyperlink.

What It Does

This formula will create a hyperlink that opens a file explorer window to the folder location where the current workbook is saved.

How It Works

LEFT(CELL(“filename”,C2),FIND(“[“,CELL(“filename”,C2))-2) will return the folder path of the current workbook. See how this part of the formula works from another post. In this example, this part of the formula returns “C:\Users\John\Google Drive – Excel\Excel Website\Formulas\How To Create A Hyperlink To The Current Workbook Folder“.

HYPERLINK(Folder,”Click Here!”) then creates a hyperlink to the Folder and displays “Click Here!” in the cell. If you click the cell once a file explorer window will open at the Folder location. Click and hold to select the cell.

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Subscribe

Advertisement

Related Articles

Comments

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest

Share This