Folder names from array

[originalJ]

Hello everyone,

I found the code below online to create a folder using the path name that I have designated

Please Login or Register  to view this content.

I would need to create subfolders into the folder that the above macro create. The folder names would be pretty consistent since it would consist of employee names. I have used a loop with lbound to ubound before referencing off an array and i'm thinking this might be the way to go but writing the code properly seems to be outside of the minimal code writing skill set that I have.

I researched it a bit but the only ones that I have found are versions of the above written code.

Here's what I have so far before I pressed the easy button and went here. It's the same exact code as the one listed above but I included a loop with lbound to ubound. It didn't pop up any errors, which is good, but it didn't really do anything.

Please Login or Register  to view this content.

I'm open to suggestions on how to write this appropriately if this might not even be a smart way of going about it.

Thanks!

[p24leclerc]

try this code:

Please Login or Register  to view this content.

[originalJ]

Perfect! Exactly what I needed.

Just curios on this part

Please Login or Register  to view this content.

Just curios, what would happen if a folder with a similar name is existing? I don't it'll ever happen since the code will be naming the folder name using the date and if it does it'll be user error.

[p24leclerc]

If the folder already exists, it can't be created again. So this part of code will be skipped
but the other part will still be run so the sub-folders would be created if they don't already exist.
If you don't want to create the sub-folders if the main folder already exist, transfer that part of the code inside the If statement for the main folder.