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