Can I create folders in explorer from an excel list

N

njmcr

I have a list in excel of names each of which need a folder created in
exlorer. Is there a way to do this? Can't find anything relevant in Help
 
G

Gary''s Student

Let's say the list of names is in column B in B1 thru B100. In column A
enter mkdir in cells A1 thru A100.

Save the file as a text file with the name:
x.bat
Then just double-click the resulting icon.
 
N

njmcr

Thanks for the reply.. just a question tho.. what file do I save as x.bat?
the excel spreadsheet? Sorry... I need real 'for non technical person'
instructions
 
N

njmcr

right I actually have the MS DOS Batch file on my desk top now... how do I
see the folders in explorer?? Sorry for the simply questions...
 
G

Gary''s Student

Don't be concerned about asking simple questions.


If you see the batch file on your desktop, double-click it. The batch file
should then execute and generate a set of folders ( probably also on your
desktop). You can then use Windows Explorer to display the Desktop and the
folders should be visible.
 
Top