Set myPath = Activeworkbook.Path

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pradhan" wrote in message
...
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