add a folder to c:\ drive from cell A1 contents...

[MattSonnier@gmail.com]

Hi all:

How do I write a VBA code in excel to add a folder on the c:\ from the
contents in cell A1.

For example, if cell A1 has Look, how could I write code that makes a
folder on the c:\ drive that is c:\look.

Any help is greatly appreciated. Cheers.

~Matt

[Ron de Bruin]

See also the VBA help for MkDir

MkDir "C:\" & Sheets("Sheet1").Range("A1").Value



--
Regards Ron de Bruin
http://www.rondebruin.nl



<MattSonnier@gmail.com> wrote in message news:1153860322.137324.106980@m73g2000cwd.googlegroups.com...
> Hi all:
>
> How do I write a VBA code in excel to add a folder on the c:\ from the
> contents in cell A1.
>
> For example, if cell A1 has Look, how could I write code that makes a
> folder on the c:\ drive that is c:\look.
>
> Any help is greatly appreciated. Cheers.
>
> ~Matt
>