VBA to create folders in a directory

[William...]

Hi)

Can I use a VBA code to create certain folders in a directory?

I want to create folders with the following names: 2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016.
I also want to create subfolders in each of this folders with the following names: 01,02,03,04,05,06,07,08,09,10,11,12.

In the following directory: O:\Countries\Data\History.

[kasan]

Cross-posted: http://www.mrexcel.com/forum/excel-q...directory.html

[William...]

That is me, just need a quick answer, decided to post in two forums simultaneously.

[William...]

Am i violating a forum rule? If yes I will delete.

[kasan]

Rules requires include a link to all other sources in your post.
About subj, this should do the trick.

Please Login or Register  to view this content.

[William...]

Cheers kasan . Works like a charm

[YasserKhalil]

@Kasan
Great code. Thanks for sharing it
As for loop part would be

Please Login or Register  to view this content.

[kasan]

@YasserKhalil
Thanks for feedback. Nice point with format, elegant.