I wonder whether it is possible to create hundreds of folders/subfolders in Windows XP from cell entries.
I have arranged the folders and subfolders to be created as follows in a worksheet:
A2 B2 C2 D2 E2
K: MyFolder 10 10-1 10-11
K: MyFolder 10 10-2 10-21
K: MyFolder 10 10-3 10-31
etc. etc. etc. etc. etc.
The requirements are as follows:
- The path characteristics for the the main folder and the first subfolder are the same for all rows, i.e. 'K:\MyFolder\'
- After that, i.e 'K:\MyFolder\' the folder names vary. A lot of subfolders already exist, i.e. the macro has to skip the creation of already existing ones, i.e. not overwrite them.
I have attached a sample file for your convenience
Help is much appreciated.
Thank you very much in advance