ThisWorkbook.Path

[azizrasul]

The folder which contains the Excel file I'm working on is

C:\Users\ar3\Documents\Key Performance Indicators\

however if I place =INFO("directory") in a cell I get

C:\Users\ar3\Documents\

Is there a function where I can get the full path of the workbook in the cell?

 

[ScottR]

That function should give you the full path of the directory you're working with which WON'T always be the same as the current file. May sound daft but have you

a) Saved the worksheet (otherwise the default directory is your documents folder)

and b) Recalculated the cell containing the formula

and c) Not opened, saved or otherwise edited anything in Excel since doing that.

---

A Quick UDF to provide path for whichever workbook it is in.

Function ThisBookPath()

ThisBookPath = ThisWorkbook.Path
End Function

 

[azizrasul]

I set the formula calculation to Automatic, saved and closed the workbook and then opened it and I still got the same answer as before.

In the Immediate window I get the full path, when I use ThisWorkbook.Path
.