What is the function to get the durrent path/directory of where my file is?

I have an excel file in which cell (A1) should contain/display the current path or directory where this said file is saved? What is that function pls.?

Thanks a lot.

You can set it through VBA, use Application.Path

Regards,

Ax

Hi

I think to get the directory of the Excel file running the code you need this

ThisWorkbook.Path

Application.Path returns the diectory of Excel.exe !!?

HTH


MTB

Yeah, you're right, you'll want to use ActiveWorkbook.Path. My bad.

hi

You could also use the CELL function in Excel:

If you want the name and path of the active spreadsheet to be entered automatically in a cell, use the formula: =CELL("filename" )

if you want only the filename use :
=MID(CELL("filename" ,A1),FIND("[" ,CELL("filename" ,A1))+1,FIND("]" ,CELL("filename" ,A1))-FIND("[" ,CELL("filename",A1))-1)