How do I use data in Excel (CVS) file to auto create Sub Folders

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for tools that would take data from colums in an excel
spreadsheet and auto-generate a folder tree structure.

What would be great is if Col. A would be Root Folder, Col. B, Sub Folder
off root, ... so on.

Any suggestions would be great.

Scott
(e-mail address removed)
 
Scott said:
I am looking for tools that would take data from colums in an excel
spreadsheet and auto-generate a folder tree structure.

What would be great is if Col. A would be Root Folder, Col. B, Sub Folder
off root, ... so on.

Any suggestions would be great.

Scott
(e-mail address removed)
Click to expand...

The simplest way would be to write a macro in Excel
that picks up the contents of each folder, then uses
Visual Basic to create the folder.

This is clearly a question for an Excel or an MS Office
newsgroup.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub to stack data n paste unique order ID lines 3
Template Folder with Excel Macros in Sub-Folders?? 0
Best method / software for graphical output from dynamic excel data 0
Copy Excel files from sub-folders but restricted to one level 6
HOW DO I USE EXCEL TO CREATE FILEs AND FOLDERS FROM A TEMPLATE? 3
Create a Folder and sub folders 4
How to create sub-folder through specific cell value? 1
Programming to create a report from raw data 10

Back
Top