Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to create folders & sub folders from a Excel list

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-02-2012
Member
 
Join Date: Jan 2012
Posts: 30
How to create folders & sub folders from a Excel list

I need to create folders with subfolders from a listing that I have in an excel document. Is there a macro that will do that for me instead of having to go to the browser and use Folder > New > Name. There are over a thousand subfolders that I need to create and don't want to do it manually. Thanks in advance to the gurus.

Reply With Quote
  #2  
Old 15-02-2012
Member
 
Join Date: Jun 2011
Posts: 632
Re: How to create folders & sub folders from a Excel list

There is a small code that you can try out.
Code:
On Error Resume Next
For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row
MkDir Cells(i,"A").Value
Next i
Reply With Quote
  #3  
Old 15-02-2012
Member
 
Join Date: Jul 2011
Posts: 632
Re: How to create folders & sub folders from a Excel list

I have had similar tasks to do, but not this exactly. I didn't use a macro, though. Instead, I made a DOS-style batch file using an extra column. For example, suppose column A holds sub-folders you want to create inside folder c:\whatever\. In B1, put ="MKDIR " & A1 and copy down for as many rows as you need.Select column B and Edit > Copy. Paste into a new Notepad window, and "save as" inside the folder c:\whatever\ with name "temp.bat" (include the quotes). Then open folder c:\whatever\ and double-click on temp.bat. Adapt or expand the example to suit your needs.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to create folders & sub folders from a Excel list"
Thread Thread Starter Forum Replies Last Post
How to place the folders in the list at the top of start Menu? CheeCha Customize Desktop 7 25-03-2012 11:30 AM
How to mount folders on external drive to user folders to create more space Dulani Hardware Peripherals 3 11-01-2012 07:25 AM
Live Mesh Folders on Desktop of other peers - can't move folders Assasin boy Windows Software 5 12-08-2010 01:05 AM
Can create folders but cannot rename them Jhonwho Operating Systems 4 28-04-2009 11:33 AM
Create Folders AmdUser Software Development 3 23-03-2009 01:18 PM


All times are GMT +5.5. The time now is 10:12 AM.