root file path

  • Thread starter Thread starter ashishprem
  • Start date Start date
A

ashishprem

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
 
Use

ThisWorkbook.Path

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looping Open and Save as CSV 9
How to get the path where a shortcut of an Excel sheet is located 2
Problem with file path to sharepoint 0
Hyperlinks property return a relative path ... 5
Open file from path in cell and open from current file path 0
Listing files with full path 2
Active or current file path 9
Restrict User to a directory 1

Back
Top