Can Excel create folders?

Originally Posted by shg

See http://www.excelforum.com/excel-prog...subfolder.html

I don't completely understand this. I have attached what I am working with. I am trying to name the folder as seen in "H".

Thanks for all the help. I know us noobs can be frustrating.

Originally Posted by shg

You want to create all the directories in col H?

In what folder?

Only the new ones. I tried using "activecell.value" but I can't seem to get it to work. I got it to creat a new folder, but the name was "Activecell.value" instead of the actual value of the cell. The folders will be moved after the files get put in them, so the macro will not be able to search for them, unless it searched my entire server.

In what folder?

I think SHG means:

• My Documents
• C:\
• C:\Temp
• X:\Whatever

Where is the root folder in which to create the new subfolders?

Originally Posted by shg

Exactly, thank you.

Sorry, They will all go into "P:\"