List Folder location & Filenames into a Table and color

[mrprofit]

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

[Excel Fox]

To be clear, are you saying you want to browse for multiple files or multiple folders?

[mrprofit]

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

[Excel Fox]

Alright, and how should the coloring of the fonts happen? Are they random colours?

[mrprofit]

forgot to say, possible list the filenames.xls with its folder path and color them with different color, thanks

[Excel Fox]

By the way, did you try to put code together from http://www.excelfox.com/forum/f13/search-directories-to-list-files-vba-86/ and http://www.excelfox.com/forum/f2/list-of-all-files-in-a-folder-196/

[mrprofit]

Color them randomly is fine,


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