ukdane
02-26-2010, 03:59 AM
Hi,
I'm looking for a quik fix code that will populate a listbox (called LSTFiles) with the names of all EXCEL files within three different folders.
I'm guessing I can just loop the same code for each of the folders, but what do I use to get the names of each excel file, and then populate it to the listbox.
Thanks in advance for your help.
Edit: When the user then selects one of the files in the listbox, I then need to code so that another listbox shows the names of all the worksheets within the selected workbook.
I'm looking for a quik fix code that will populate a listbox (called LSTFiles) with the names of all EXCEL files within three different folders.
I'm guessing I can just loop the same code for each of the folders, but what do I use to get the names of each excel file, and then populate it to the listbox.
Thanks in advance for your help.
Edit: When the user then selects one of the files in the listbox, I then need to code so that another listbox shows the names of all the worksheets within the selected workbook.