directory creator

G'Day Members,

I'm wondering if there is a method where a list of directories and subdirectories in excel can be created as directories in a windows environment?

The excel sheet attached outlines how the directory structure would be setup in the spreadsheet.

I would love to simply run a macro, the directories and subdirectories are created and vwala.

Any ideas? This one is wwaayyyy out of my league in regards to Excel macro creation.

Based on your example, this would work:

Please Login or Register  to view this content.

Remember, you have to put the parent directories first, then subdirectories or it won't work.

This is better, you can just list the path all the way down to the deepest subdirectory, it will create all the directories all the way down without you having to list them all separately.

Please Login or Register  to view this content.

So based on these strings, it will create 11 different directories for you:
C:\2011\Test
C:\2012\Test
C:\2013\Test\DeepTest
c:\2014\Test\DeeperTest\Holycowthisisdeep

Thank you very much JB!

That's a solid base to start with.

Muchly appreciated.

Forgive my ignorance on this one but where do we specify what path we want to map out? Also, how would I edit the code to produce the actual file names with extensions?

Thanks

This thread is not about making files, this thread is about making directories on your hard drive.

Since every post in this thread includes not only the code but sample files showing how it's laid out, I trust you can look at those to answer your "how to" questions.