Excel – How To Get A Full File Path?

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 Directoryfilename.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