Ever needed to find out the full path of your current file? What I mean by full path here is the full location of the active file including the directory path and full file name.
If you did, then what you need is this following code:
Application.ActiveWorkbook.FullName
The one line code will return the full directory path + filename of the active file, ex:
D:\My Directory\filename.xls
To simply use it from our formula bar, we can wrap the code into excel vba function like this:
Function FULLFILENAME()
FULLFILENAME = Application.ActiveWorkbook.FullName
End Function
Every time we needed the information, just call the FULLFILENAME function from the formula bar.
Pingback: fast cash advance loan