Automatic folder creation from a list in Excel Solved

Question

Hello forum,

First of all, I'm not quite sure if this post belongs in the office forum. Feel free to let me know if I should rather head to the Windows forum or Programming.

My question is as follows: is it possible to automatically create folders from an Excel file that contains the list of folder names I want to create (about a thousand folders)?

Configuration: Windows 7 / Firefox 17.0

gbinforme · Accepted Answer

Hello verolyde,

Here is your workbook with the modified macro:

https://www.cjoint.com/?DGrju1v9iAj

To create your subdirectories, I used a loop that makes it easier to manage their number.
--
Always zen
Perfection is achieved not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry

gbinforme · Answer

Hello,

There is no formula that allows you to create folders, but with a macro it's quite simple.

If you could provide us with an example without personal elements but with the structure of the data on https://www.cjoint.com/ and then share the generated link here, it would be easier.
--

Always zen
Perfection is attained not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry

mike the llama · Answer

Hello gbinforme (and thank you for your response!),  The file is available at this address: https://www.cjoint.com/?3LjtfReZb2s  I've never used a macro... but it will be an experience for me!

mike the llama · Answer

Exactly, a directory for each name.  I will then take care of grouping the directories by letter in one of the 26 parent directories. I can do that manually without any problem.

gbinforme · Answer

Hello Mike the Llama,

Here is your workbook (xlsm due to the macro) with a button to choose your directory and create your directories in the 26 parent directories.

https://www.cjoint.com/?BLjw6JNx2pn

You need to enable macros (button under the ribbon) for it to work.
--
Always zen
Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry

mike the llama · Answer

Well, that's a good ten hours of repetitive work saved thanks to you! Two clicks and it's all set with the xlsm file you created.

Thank you very much for the time you spent on this!

P.S.: Could you tell me how to proceed to view (if possible) what the macro looks like in terms of programming? Just to try to understand how it works under the hood.

jpdxb · Answer

Hello Gbinforme,

Impressive!

I've finally found a topic that’s close to what I want to do, so I'm trying; maybe you can help me?

I have a list in an Excel file (just one column) with the names of partners for my site.

On the other side, I have a very simple HTML file (basically an image in the middle and a bit of text), and I have a partner link on the image (e.g., partnerid=partner1).

I need to change the source code, it can also be a txt file that I can modify into HTML afterwards, the name of the partner for each file, and the name of each partner is in my Excel file list.

So I would need it to create an HTML file for each line in Excel, with the correct file name and the correct partnerid=partner1 or partnerid=partnerxyz, etc.

Do you think this is feasible? Or should I look into other types of code or directly into command windows to achieve this?

Thanks for your help,
JP

AlbanR · Answer

Hello gbinform,  I have the same need, could you help me?  I need to create folders and subfolders.  To start, how should I organize my Excel sheet?

verolyde · Answer

Good evening,

Thank you for your prompt response. I uploaded the file on cjoint.com

http://cjoint.com/data3/3GqvmPC168T_modeles_mal_maj_110714.xls

What you did above is great. I tried to modify it to create 11 subdirectories, but I couldn't manage it.

Thank you so much for your help!
Verolyde

verolyde · Answer

Thank you a thousand times for your help!  Best regards  Vérolyde

verolyde · Answer

Could you tell me, for my understanding, where the problem was?

romain06130 · Answer

Hello,
would you be kind enough to help me create a macro capable of generating folders from a list of keywords in Excel?

The principle is as follows: I have made a list of 2000 keywords, and I would like each line containing a keyword in my Excel file to transform into a folder somewhere on my Mac.
The second step is that at the same time, a web page should be generated inside each new folder. It should be systematically named "index.htm". Furthermore, each web page generated should contain identical content except for one variable (present multiple times on the page): the famous keyword from the folder name.

If you understood my gibberish, thank you in advance for your help :))

Davide · Answer

Hello everyone,

My question is the same: I'm looking to create directories from a spreadsheet list.
I've tried to modify the macro, but it's beyond my skills!

I've uploaded an excerpt of the xls file here: http://www.cjoint.com/c/ELxiy0tAMuE
I'm using Windows 7 pro and LibreOffice.

Thank you for your help.

Automatic folder creation from a list in Excel

13 answers

Color of visited links in firefox 153

How to tell if i can upgrade the ram on my pc?

Windows security

E.tre456.worm.windows

Broken logitech g915 keyboard key (original part)

Computer stuck at boot menu on startup page

Texture issues in enshrouded

Printer uninstalled

Pc audio connection: jack ports, hi-fi chain

Recording and reading issue for jpg files