I am trying to do something that I don't know if anyone else might have tried before...I am writing a Macro in Excel that will give a user the list of all the folders present within a selected folder. I have been successful in getting that onto a spreadsheet using the Shell command...

This is important for Project Managers who need to work with a lot of directories for their projects...especially when they want to create a new one for their project taking an old one as a base...the PM would typically add/modify/delete from the existing directory structure.

Now here is what I want:
I want the user to be able to add/modify/delete the directory structure according to his/her needs and specify a location and hit some button - that will create the new directory structure at the new location specified by the user. The problem is that the dump that I get from the Shell command is not very user friendly to add/modify/delete the directories. For example:
User wants the dump of C:\Data and gets the following on a spreadsheet (with the Shell command) -

where Exchange, n014996 and N212710 are the folders within C:\Data. Temp is the only folder within Exchange. Similarly, the folder n014996 contains 5 sub-folders. There are no sub-folders within N212710.

Here, the user may choose to add a new folder within C:\Data or modify any of the existing folders or even delete. I want the user to be able to do it with the help of some GUI where he can see the entire folder structure in a Tree format (the way Windows explorer shows it). Any ideas how I can achieve that using VBA and Excel?

Satish, I am not familiar with a Treeview control. But I do know that there are plenty of ways for Excel VBA to interact with the microsoft folder system.
I suggest that you go in to the Excel VB Editor and open the VB Help (not Excel's) and type in the search field
dir
that will lead you to lot's of functionality for dealing with files and folders, combine that with string manipulation and you should be able to do something.

THIS THREAD HAS EXPIRED.
Are you having the same problem?
We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.