Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ------------------------------------------------------------------------ ashishprem's Profile: http://www.excelforum.com/member.php...o&userid=31485 View this thread: http://www.excelforum.com/showthread...hreadid=517219 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
root file path
Use
ThisWorkbook.Path -- HTH Bob Phillips (remove nothere from email address if mailing direct) "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
root file path
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Variabilize File Path or File Name in SumProduct (and Vlookup too) | Excel Worksheet Functions | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
How set file open path to filepath of file opened with Explorer ? | Excel Programming |