Creating folders and subfolders from excel file list

I need to create folders with subfolders from a listing that I have in an
excel document. Is there a macro that will do that for me instead of having
to go to the browser and use "Folder>New>Name" There are over a thousand
subfolders that I need to create and don't want to do it manually.

Thanks in advance to the gurus.

Allie :-)

On Error Resume Next
For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row
MkDir Cells(i,"A").Value
Next i

--

HTH

RP
(remove nothere from the email address if mailing direct)


"afaubert" <[email protected]> wrote in message
news:[email protected]...
> I need to create folders with subfolders from a listing that I have in an
> excel document. Is there a macro that will do that for me instead of
having
> to go to the browser and use "Folder>New>Name" There are over a thousand
> subfolders that I need to create and don't want to do it manually.
>
> Thanks in advance to the gurus.
>
> Allie :-)

> I need to create folders with subfolders from a listing that I have in
> an excel document. Is there a macro that will do that for me instead
> of having to go to the browser and use "Folder>New>Name" There are
> over a thousand subfolders that I need to create and don't want to do
> it manually.

I've had similar tasks to do, but not this exactly. I didn't use a macro,
though. Instead, I made a DOS-style batch file using an extra column.

For example, suppose column A holds sub-folders you want to create inside
folder c:\whatever\

In B1, put
="MKDIR " & A1
and copy down for as many rows as you need.

Select column B and
Edit > Copy

Paste into a new Notepad window, and "save as" inside the folder
c:\whatever\ with name
"temp.bat"
(include the quotes).

Then open folder c:\whatever\ and double-click on temp.bat.

Adapt or expand the example to suit your needs.

For more on the command language, a good reference is
http://home7.inet.tele.dk/batfiles/msdos7/

BEAUTIFUL!!!! Thanks, works like a charm!

"Jay" wrote:

> > I need to create folders with subfolders from a listing that I have in
> > an excel document. Is there a macro that will do that for me instead
> > of having to go to the browser and use "Folder>New>Name" There are
> > over a thousand subfolders that I need to create and don't want to do
> > it manually.
>
> I've had similar tasks to do, but not this exactly. I didn't use a macro,
> though. Instead, I made a DOS-style batch file using an extra column.
>
> For example, suppose column A holds sub-folders you want to create inside
> folder c:\whatever\
>
> In B1, put
> ="MKDIR " & A1
> and copy down for as many rows as you need.
>
> Select column B and
> Edit > Copy
>
> Paste into a new Notepad window, and "save as" inside the folder
> c:\whatever\ with name
> "temp.bat"
> (include the quotes).
>
> Then open folder c:\whatever\ and double-click on temp.bat.
>
> Adapt or expand the example to suit your needs.
>
> For more on the command language, a good reference is
> http://home7.inet.tele.dk/batfiles/msdos7/
>

I will try and embed this in my macro and see if it works! Thanks Bob!!!
:-)

"Bob Phillips" wrote:

>
> On Error Resume Next
> For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row
> MkDir Cells(i,"A").Value
> Next i
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "afaubert" <[email protected]> wrote in message
> news:[email protected]...
> > I need to create folders with subfolders from a listing that I have in an
> > excel document. Is there a macro that will do that for me instead of
> having
> > to go to the browser and use "Folder>New>Name" There are over a thousand
> > subfolders that I need to create and don't want to do it manually.
> >
> > Thanks in advance to the gurus.
> >
> > Allie :-)
>
>
>