1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Tree View in Excel

Discussion in 'Business Applications' started by mailsatk, Oct 31, 2006.

Thread Status:
Not open for further replies.
Advertisement
  1. mailsatk

    mailsatk Thread Starter

    Joined:
    Mar 11, 2005
    Messages:
    65
    Hello people!

    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) -

    http://img135.imageshack.us/img135/6644/screenprintiv2.png

    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?

    Thanks!
    -Satish
     
  2. mailsatk

    mailsatk Thread Starter

    Joined:
    Mar 11, 2005
    Messages:
    65
  3. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    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.
     
  4. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
  5. mairembam

    mairembam

    Joined:
    May 21, 2008
    Messages:
    1
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/514261