Can Excel create folders?

[jamesstorx]

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?

[Leith Ross]

Hello jamesstorx,

If you mean is it possible to create a folder using a worksheet formula then the answer is no. It is possible using VBA.

[shg]

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

[jamesstorx]

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.

[shg]

You want to create all the directories in col H?

In what folder?

[jamesstorx]

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.

[Palmetto]

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?

[shg]

I think SHG means: ...

Exactly, thank you.

[jamesstorx]

Exactly, thank you.

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

[shg]

Run Sub x. Untested ...

Please Login or Register  to view this content.

[jamesstorx]

How can I get it to only create the new folders? this works great, but copies all the folders. would it be best to delete H after running the program each time?

You guys truly amaze me. In 5 minutes you can get done what has taken me all day to not get done.

Thanks.

[shg]

It only does create the folders that do not already exist.

[jamesstorx]

It only does create the folders that do not already exist.

But if I move the new folder into another sub-folder then it will be duplicated.

[shg]

If what you mean is ...

You create the directories in P:\

Then you then move those directories into some other directory, e.g., P:\somplaceElse\

Then you create the directories again in P:\

.. then yes, of course, there will be two directories having the same name in different directories. There are not duplicates, they are different directories.

[jamesstorx]

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

[shg]

Probably, if you explain clearly what you're trying to do.

[jamesstorx]

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.

[shg]

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

You're welcome, and people wouldn't post here if they knew how to do what they wanted.

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:\.

That's correct.

So just run the code once. I know that's not the answer, but still don't understand what you're trying to do.

Draw a directory tree after the code runs once:

Please Login or Register  to view this content.

Then another after you move stuff around; then another showing what you want to happen after the code runs again.