Create macro to create unique folder from excel file with generic sub file stucture

I am trying to create code that will extract a unique file name from excel and create a generic sub folder under each unique folder.

Example:
Unique Folder
- Project A
Sub Folder structure
- Initiation Phase
- Definition Phase
- Execution Phase
- Close Out Phase

I have found and adapted the below code from another post on this forum to create the unique folder but am unable to code the generic folder creation part

Any assistance in this development is appreciated.

Please Login or Register  to view this content.

srf_art,

You should be able to use the following:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Works a treat thanks tigeravatar