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