Can Excel create folders?

I am wondering if it is possible to get excel to Create a new folder from a cell value? I am entring data into cells Eg A1-F1, and then the next line of data is in A2-F2 and so on. What I'd like is when I enter data (the date) in the F column then it will create a folder with the value of H2 (=A2&B2&D2&E2)

Is this possible?

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?

Is there a way that I can only have it do it once?

I want to have excel create the folder, in P:\. Then I will move the folder into an appropriate subfolder based on the contents of the folder. I need to only have the folders created once, and I my understanding is that once the folder is moved it will be made again because it no longer resides in P:\.

I am sorry if my inexperience is making this diffucult. I really do appreciate all your help.

Thanks again.