Results 1 to 7 of 7

Thread: List Folder location & Filenames into a Table and color

  1. #1
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0

    List Folder location & Filenames into a Table and color

    Attached is the WB i am working on, code modified from other forum,

    now i want to use the "Browse for Folder" to select the folder where the files is in eg. E:\My Docs\Global\ and list the folder location and filenames to table (column I:J), and color them according to every folder location.

    I would like the "Browse for Folder" windows to be able to select multiple files instead of just one file a time.


    Appreciate for any help, thank you
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    To be clear, are you saying you want to browse for multiple files or multiple folders?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0
    Just to able to select multiple files instead of just one files, or can select a folder and will list every filenames.xls within

    The current button only can get one file path, and one folder path,
    Folder path is not that important, all the file names to list is the main thing I need.

    Thank you for helping
    Last edited by mrprofit; 04-14-2014 at 10:50 PM.

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Alright, and how should the coloring of the fonts happen? Are they random colours?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  5. #5
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0
    forgot to say, possible list the filenames.xls with its folder path and color them with different color, thanks

  6. #6
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  7. #7
    Member
    Join Date
    Apr 2014
    Posts
    45
    Rep Power
    0
    Color them randomly is fine,


    Thank you, your codes show it in msg box, how to list it into the table?

Similar Threads

  1. Did You Know ::: Automatic Subtotals (& More) :: Data List Outline
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 09-23-2013, 03:13 PM
  2. Change Pivot Table Data Source Using A Drop Down List
    By hanishgautam in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-05-2013, 09:33 AM
  3. List File name in folder to excel with images
    By Ryan_Bernal in forum Excel Help
    Replies: 2
    Last Post: 01-15-2013, 11:37 AM
  4. Replies: 2
    Last Post: 09-24-2012, 06:24 PM
  5. List Of All Files In A Folder
    By Excel Fox in forum Excel Help
    Replies: 2
    Last Post: 10-27-2011, 09:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •