software

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?

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 amp; I'm adding to all users desktop);

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

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Mattquot; wrote:

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

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 = quot;c:\quot;

Do Until ActiveCell.Value = quot;quot;
MkDir BasePath amp; ActiveCell.Value
ActiveCell.Offset(1, 0).Select
Loop

End SubFOrgot to mention: you can change the value of BasePath to match your
exact needs.I followed your procedure and after double clicking on the .BAT file dos
performed something but the folders were not created ..... any other ideas?

quot;Chris Marlowquot; wrote:

gt; Matt,
gt;
gt; When I need to do something like this quick and dirty (rather than something
gt; I think will be repeated - where I'd probably delve into code) I do something
gt; like this (say my names are in column A amp; I'm adding to all users desktop);
gt;
gt; 1) Write a formula =quot;mkdir quot;quot;C:\Documents and Settings\All
gt; Users\Desktop\quot;amp;A1amp;quot;quot;quot;quot; and drag down as needed.
gt; 2) Drop the contents into notepad amp; save as something.BAT
gt; 3) Find something.BAT in Explorer amp; double click (or use command line - same
gt; difference).
gt;
gt; Regards,
gt;
gt; Chris.
gt;
gt; --
gt; Chris Marlow
gt; MCSD.NET, Microsoft Office XP Master
gt;
gt;
gt; quot;Mattquot; wrote:
gt;
gt; gt; I have a spreadsheet with 2200 names on it, and I would like to create a
gt; gt; folder (on my desktop, or hard drive) for each individual one without
gt; gt; creating them one and a time 2200 times. Does anyone know how to do this?

Matt,

Could it be that you parent directory does not exist? Can you navigate amp;
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 quot;cdquot; to navigate to the folder containing
file - type the name in hit return amp; it will run.

Or try Dave O's code ...

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Mattquot; wrote:

gt; I followed your procedure and after double clicking on the .BAT file dos
gt; performed something but the folders were not created ..... any other ideas?
gt;
gt; quot;Chris Marlowquot; wrote:
gt;
gt; gt; Matt,
gt; gt;
gt; gt; When I need to do something like this quick and dirty (rather than something
gt; gt; I think will be repeated - where I'd probably delve into code) I do something
gt; gt; like this (say my names are in column A amp; I'm adding to all users desktop);
gt; gt;
gt; gt; 1) Write a formula =quot;mkdir quot;quot;C:\Documents and Settings\All
gt; gt; Users\Desktop\quot;amp;A1amp;quot;quot;quot;quot; and drag down as needed.
gt; gt; 2) Drop the contents into notepad amp; save as something.BAT
gt; gt; 3) Find something.BAT in Explorer amp; double click (or use command line - same
gt; gt; difference).
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Chris.
gt; gt;
gt; gt; --
gt; gt; Chris Marlow
gt; gt; MCSD.NET, Microsoft Office XP Master
gt; gt;
gt; gt;
gt; gt; quot;Mattquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet with 2200 names on it, and I would like to create a
gt; gt; gt; folder (on my desktop, or hard drive) for each individual one without
gt; gt; gt; creating them one and a time 2200 times. Does anyone know how to do this?

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.

quot;Mattquot; wrote:

gt; I followed your procedure and after double clicking on the .BAT file dos
gt; performed something but the folders were not created ..... any other ideas?
gt;
gt; quot;Chris Marlowquot; wrote:
gt;
gt; gt; Matt,
gt; gt;
gt; gt; When I need to do something like this quick and dirty (rather than something
gt; gt; I think will be repeated - where I'd probably delve into code) I do something
gt; gt; like this (say my names are in column A amp; I'm adding to all users desktop);
gt; gt;
gt; gt; 1) Write a formula =quot;mkdir quot;quot;C:\Documents and Settings\All
gt; gt; Users\Desktop\quot;amp;A1amp;quot;quot;quot;quot; and drag down as needed.
gt; gt; 2) Drop the contents into notepad amp; save as something.BAT
gt; gt; 3) Find something.BAT in Explorer amp; double click (or use command line - same
gt; gt; difference).
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Chris.
gt; gt;
gt; gt; --
gt; gt; Chris Marlow
gt; gt; MCSD.NET, Microsoft Office XP Master
gt; gt;
gt; gt;
gt; gt; quot;Mattquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet with 2200 names on it, and I would like to create a
gt; gt; gt; folder (on my desktop, or hard drive) for each individual one without
gt; gt; gt; creating them one and a time 2200 times. Does anyone know how to do this?

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.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Mattquot; wrote:

gt; Actually Chris' method solved it just instead of have All Users in the path
gt; you I needed to use my exact user name .... unless maybe that is now being
gt; sent throughout the entire corporation, and about 4000 people will be pretty
gt; upset, o well
gt; Thanks for the help.
gt;
gt; quot;Mattquot; wrote:
gt;
gt; gt; I followed your procedure and after double clicking on the .BAT file dos
gt; gt; performed something but the folders were not created ..... any other ideas?
gt; gt;
gt; gt; quot;Chris Marlowquot; wrote:
gt; gt;
gt; gt; gt; Matt,
gt; gt; gt;
gt; gt; gt; When I need to do something like this quick and dirty (rather than something
gt; gt; gt; I think will be repeated - where I'd probably delve into code) I do something
gt; gt; gt; like this (say my names are in column A amp; I'm adding to all users desktop);
gt; gt; gt;
gt; gt; gt; 1) Write a formula =quot;mkdir quot;quot;C:\Documents and Settings\All
gt; gt; gt; Users\Desktop\quot;amp;A1amp;quot;quot;quot;quot; and drag down as needed.
gt; gt; gt; 2) Drop the contents into notepad amp; save as something.BAT
gt; gt; gt; 3) Find something.BAT in Explorer amp; double click (or use command line - same
gt; gt; gt; difference).
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Chris.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Chris Marlow
gt; gt; gt; MCSD.NET, Microsoft Office XP Master
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Mattquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a spreadsheet with 2200 names on it, and I would like to create a
gt; gt; gt; gt; folder (on my desktop, or hard drive) for each individual one without
gt; gt; gt; gt; creating them one and a time 2200 times. Does anyone know how to do this?