Use =CELL("filename") and parse out the part of the string that you need.
--
Gary's Student


"Pradhan" wrote:

Is there anyway to pull either the complete path or alternatively, the parent
folder of the xls file. For example, example.xls is located in the
c:\november directory,
I'd like to pull in either C:\november or just november.

Thanks
Pradhan