Values to a folder name on desktop

M

Matt

I have a spreadsheet with 2200 names on it, and I would like to create a
folder (on my desktop, or hard drive) for each individual one without
creating them one and a time 2200 times. Does anyone know how to do this?
 
C

Chris Marlow

Matt,

When I need to do something like this quick and dirty (rather than something
I think will be repeated - where I'd probably delve into code) I do something
like this (say my names are in column A & I'm adding to all users desktop);

1) Write a formula ="mkdir ""C:\Documents and Settings\All
Users\Desktop\"&A1&"""" and drag down as needed.
2) Drop the contents into notepad & save as something.BAT
3) Find something.BAT in Explorer & double click (or use command line - same
difference).

Regards,

Chris.
 
D

Dave O

This macro will do it... you'll need an uninterrupted list of names
with no duplications. If I can editorialize for one nanosecond, it
seems to me that 2200 folders will be very difficult to administer.

Sub Long_List_of_Directories()
Dim BasePath As String
BasePath = "c:\"

Do Until ActiveCell.Value = ""
MkDir BasePath & ActiveCell.Value
ActiveCell.Offset(1, 0).Select
Loop

End Sub
 
M

Matt

I followed your procedure and after double clicking on the .BAT file dos
performed something but the folders were not created ..... any other ideas?
 
C

Chris Marlow

Matt,

Could it be that you parent directory does not exist? Can you navigate &
check in Windows Explorer?

Additionally you could try running the BAT file through the command line -
will tell you what the errors are (they come up when you run it but probably
to quick to read).

Do Start, Run cmd (return) - use "cd" to navigate to the folder containing
file - type the name in hit return & it will run.

Or try Dave O's code ...

Regards,

Chris.
 
M

Matt

Actually Chris' method solved it just instead of have All Users in the path
you I needed to use my exact user name .... unless maybe that is now being
sent throughout the entire corporation, and about 4000 people will be pretty
upset, o well
Thanks for the help.
 
C

Chris Marlow

Matt,

No worries - should just be local to your PC. The 'all users' area just
means it can be shared by all users logging onto your PC (in theory).

Regards,

Chris.
 
Top