Hey,

I know this may have been asked many times before however I am having trouble with a macro creating folders and subfolders.

I have attached a spreadsheet with macro that I took from the site which is exactly what I want (if it worked!). The issue I am having is that I can get it to create the parent directory "test" in the location specified however none of the sub folders are created?

When I initially ran the macro there was a missing reference to "personal.xls" which I removed - maybe this is causing the problem?

Many thanks in advance,

Qoios

file - Make Dir Tree.xlsm