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
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
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.
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
forgot to say, possible list the filenames.xls with its folder path and color them with different color, thanks
By the way, did you try to put code together from http://www.excelfox.com/forum/f13/se...-files-vba-86/ and http://www.excelfox.com/forum/f2/lis...-a-folder-196/
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
Color them randomly is fine,
Thank you, your codes show it in msg box, how to list it into the table?
Posting Permissions
Reply With Quote
Bookmarks