Get the Path of Current Worksheet

How to Get the Path of Current Worksheet In Excel?

In case you need a smart way to get the path of the current Excel workbook without VBA, then this article is for you. We will use formula based approach.


Question:I want to find out the path of the active sheet through a formula.


The function used in this tutorial will work on following versions of Microsoft Excel:

Excel 2013, Excel 2010, Excel 2007, Excel 2003


We will use a combination of SUBSTITUTE, CELL, FILENAME, RIGHT, LEN, FIND functions.


Enter the following formula in any cell of the worksheet

  • =SUBSTITUTE(CELL("filename"),RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("@",SUBSTITUTE(CELL("filename"),"\","@",LEN(CELL("filename"))-LEN(SUBSTITUTE(CELL("filename"),"\",""))),1)),"*")

image 1


In this way, we can retrieve the path of the current worksheet in Excel without using VBA coding.


Download-How to get the path of current worksheet




Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube