I am using the following code to create a directory if it does not exist. If cell C4 has “12400” then a directory “12400-12499” is created i.e. "S:\MTL_DATA\Quotes\12400-12499".
I wish to know how to modify this code so that another sub directory is created, in this case “12400” i.e. "S:\MTL_DATA\Quotes\12400-12499\12400". If cell C4 has 12401 then "S:\MTL_DATA\Quotes\12400-12499" remains but a new sub directory is “12401” i.e. "S:\MTL_DATA\Quotes\12400-12499\12401".
Thanks Sandy
![]()
Please Login or Register to view this content.
Bookmarks