Solved: create multiple folders from worksheet

[pdeshazier]

is there a way to create folders from a spreadsheet? For example: If I wanted to create a folder for every employee and scan documents to that folder, could I take a spreadsheet that had every employee listed in a column and convert those into folder names.:dunno

[Bob Phillips]

For Each cell In Range(Range("A1"), Range("A1").End(xlDown))

MkDir "C:\myDir\" & cell.Value
Next cell

[pdeshazier]

:bow: it worked!! thanks so much



For Each cell In Range(Range("A1"), Range("A1").End(xlDown))

MkDir "C:\myDir\" & cell.Value
Next cell

[mdmackillop]

Remember to mark your threads solved.

[pdeshazier]

done. thanks.

Remember to mark your threads solved.