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

M

MattSonnier

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
 
R

Ron de Bruin

See also the VBA help for MkDir

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