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.

xlsx-1567

Download-How to get the path of current worksheet

 

 

 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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 Google PlusVisit Us On Youtube