Hi all,
What I was looking for :
- Using VBA, a way to create a new folder in a user defined filepath
- and whose name is a USER INPUT (using INPUT BOX)
What I tried :
two things
this made a file of my choice. However, the filepath changes everytime someone new works on this project and so does its folder name. therefore I tried![]()
Please Login or Register to view this content.
also tried :![]()
Please Login or Register to view this content.
Result : always created a folder by the name "filenewname"![]()
Please Login or Register to view this content.
Now this just takes me to the path. It neither asks for a folder name nor creates a new folder.
My doubts:
- where to write the code for the input box in the above code? is it after "END WITH" line ?
- How to modify MkDir command so as to create a new folder based on the new user input (the folder name)
-subbby
Bookmarks