Hello, I'm trying to return the active path and filename in a cell: C:\Foldername\Filename.xlsm ..
If I use formula: =cell('filename"), it returns C:\Foldername[Filename.xlsm]SheetName
I don't want the sheetname, nor the filename in brackets, so I found the following formula that replaces the brackets, but it gets rid of both the filename and sheetname, leaving only the path: =LEFT(K1,FIND("|",SUBSTITUTE(K1,"\","|",LEN(K1)-LEN(SUBSTITUTE(K1,"\","")))))
I was able to go into Options and add filepath to the quick access bar.. If there is a way to reference it in a cell, that would work as well.
Any ideas? Thanks!
Bookmarks