Every one of us requires a lot of folders on our computers
for various functions. And we do so in a seamless manner. It's simple and
quick. Until the day comes when you need to make a large number of folders at
once. As you are reading this, that day has arrived. I've written an article
about how to generate several folders from a list. If you already have a list
in Excel and need to create folders based on it, that tutorial is for you.
However, in this lesson, I'll take a different method to solve that problem, as
well as provide some additional benefits.
Here are some of the things you'll find:
- Excel will create a folder on your PC whenever you type something in a cell.
- If you paste a list into Excel, it will generate all of the folders based on that list on your computer at once.
- The cell values in your excel file will be used to name the newly generated folders.
- This workbook can also be used as a template that you can use anywhere.
I hope I've piqued your interest. I'll now use excel to
create folders on my computer. I'm not going to use any shell commands or
anything like that. Instead, I'll use Excel VBA to complete this operation. The
code is divided into two sections. The first portion is an event-based macro,
while the second is the actual code that does the task.
Let's have a look at how to make folders in Excel:
Step 1: Make an Excel workbook and save it as an.xlsm Excel
macro-enabled workbook.
Step 2: Select "view code" from the context menu
when right-clicking on the sheet name.
Step 3: Write the code. Take the code from this tutorial.
Step 4: Finish by saving the workbook.
When you utilize the workbook, a couple of things will
happen.
- If you type something in Column A, your computer will create folders for you.
- It will create folders based on each item you add to the list, even if you paste a full list on Column A.
- Only where you have saved the excel workbook will folders be created. Keep the workbook saved on your desktop, for example, if you wish to create folders on your desktop. Keep the spreadsheet file preserved on Drive D if you want to create folders on Drive D. In a nutshell, this code will look for your excel file's location and then create folders at that point.
What you can do to maximize the file's potential.
Assume you're in charge of filing for your clients. Make a list of all the documents you want to save in Excel. If you wish, you can watch a video on how to make checkboxes in Excel. It will be fantastic if you do it in the workbook you just prepared. In Column A, type the client's name, and a folder for that client will be generated immediately. Now mark which documents you received and place them in the appropriate folder. Isn't it fantastic? Here, the possibilities are unlimited. Let me know how you use this strategy in the comments. That makes me happy to hear.
Comments
Post a Comment