Path location in a cell

[gheyman]

Is there a way to put the files location/Path in a cell?

 

[bellman101]

if you are familiar with VBA you can use

Range("A1") = Thisworkbook.fullname '(For file path and workbook name)

or

Range("A1") = left(Thisworkbook.fullname,Len(Thisworkbook.fullname)-Len(Thisworkbook.name))

The latter will give you the file path without the workbook name included.

Hope this helps
Thanks
James

 

[gheyman]

Thank you. That worked

 

[ashish koul]

try this formula
=SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),"[","")