PDA

View Full Version : Solved: create multiple folders from worksheet



pdeshazier
02-23-2009, 03:31 PM
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
02-23-2009, 04:06 PM
For Each cell In Range(Range("A1"), Range("A1").End(xlDown))

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

pdeshazier
02-24-2009, 07:35 AM
: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
02-24-2009, 10:19 AM
Remember to mark your threads solved.

pdeshazier
02-24-2009, 12:48 PM
done. thanks.

Remember to mark your threads solved.