ashishprem,
Check out ThisWorkbook.Path

NickHK

"ashishprem" wrote
in message ...

Hi,
I want to create a directory using the macro. I got the code to create
a directory. But i want to place the directory in the same path where
the file conatining macro is there.
Suppose the excel file path is in C:\Project\test.xls then the file
should also be placed in the path C:\Project.

Regards,
Ashish


--
ashishprem
------------------------------------------------------------------------
ashishprem's Profile:
http://www.excelforum.com/member.php...o&userid=31485
View this thread: http://www.excelforum.com/showthread...hreadid=517219