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
In this way, we can retrieve the path of the current worksheet in Excel without using VBA coding.
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.