root file path

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,
Check out ThisWorkbook.Path

NickHK

"ashishprem" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Use

ThisWorkbook.Path

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ashishprem" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>