You would use the MkDir statement to do that... it requires you specify the
full path as its argument. This is the description provided in the help
files...

"Creates a new directory or folder.

Syntax: MkDir path

The required path argument is a string expression that
identifies the directory or folder to be created. The path
may include the drive. If no drive is specified, MkDir
creates the new directory or folder on the current drive."

--
Rick (MVP - Excel)


"primed" wrote in message
...
Hi,

I have a list of names in excel, approx 500 long. I need to create a
folder
for each one. How do i do it automatically?

Thanks