Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Creting Folder Via Excel VBA

Posted on 2014-09-23
10
227 Views
Last Modified: 2014-09-26
Hi Experts,

Is there is way to create folder via excel VBA.
I have two list of data  - column 1 all Sector names, column 2 list of  the company's . Want to create all sector folder & in that folders want to create Sub Folders of companies name as per in which its sector.

See attached.
0
Comment
Question by:itjockey
  • 6
  • 3
10 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 40340905
No attachment.
0
 
LVL 8

Author Comment

by:itjockey
ID: 40340966
0
 
LVL 8

Author Comment

by:itjockey
ID: 40341094
Are you with me?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 16

Expert Comment

by:Jerry Paladino
ID: 40341166
itjockey,

I have used the code from Chip Pearson's MakeMultiStepDirectory for several projects and it has worked well for me.   The full code and explanation of the steps is located at:  
http://www.cpearson.com/excel/MakeDirMulti.aspx

HTH,
Jerry
0
 
LVL 8

Author Comment

by:itjockey
ID: 40341185
0% knowledge of VBA Coding...
0
 
LVL 16

Accepted Solution

by:
Jerry Paladino earned 500 total points
ID: 40345316
The attached file should create your subdirectories of Sector and Company names.   The program requires that you provide a Base subdirectory that already exists and your subdirectory names will be created below that base directory.   If you want to include periods in the subdirectory names, you must check the checkbox as shown below.  The fully qualified subdirectory name that will be created is in the column "SubDirName".Q_28524413 worksheet pageQ-28524413-Create-Multiple-Subdirectorie
0
 
LVL 8

Author Comment

by:itjockey
ID: 40345371
Mr.ProdOps,

I thought it will take at least 30 Second to create all folders. But what happened - one click and done.....surprised ...  :)
 If you want to include periods in the subdirectory names, you must check the checkbox as shown below.  The fully qualified subdirectory name that will be created is in the column "SubDirName".

As my question is solved ...just for understanding ...what do I mean y this?

Thank you very Much
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 40345373
Perfect & Awesome.
0
 
LVL 16

Expert Comment

by:Jerry Paladino
ID: 40345710
If you want to include periods in the subdirectory names, you must check the checkbox as shown below.
The code originally written by Chip Pearson checks for a period after the last slash (\)  in the subdirectory name.  If it finds a period after the last slash, it assumes the name is a file name and skips that record, not creating the subdirectory name.  As an Example, if it found the record - "C:\User\ITJockey\Medical\Vitacorp\ExpenseReports.xlsm" within the list, it would skip that record and move to the next one.

There were four records in the data you provided that had periods as part of the Company name.  In order to create those four, I added an IF statement in the VBA code to see if the Checkbox was checked and bypass the check for a period after the last slash if it was.

HTH,
Jerry
0
 
LVL 8

Author Comment

by:itjockey
ID: 40345734
OK Thanks......


if you have time pls look in to this .csv To .txt


Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question