Using VBScript to list all folders in a directory and files ...

G

Guest

Hi, I'd like to have my Excel files scanning the folder it is in for folders,
then listing those folders in a drop-down list. Furthermore, when a folder is
selected in the drop-down list, I'd like Excel to import data from multiple
CSV files placed in that folder. The CSV file names are static.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List ALL folders and files 2
How to find folders in a directory 2
List all folders and files 2
Macro to generate list of folders 2
Using VBA to move system files 2
find newest file in all sub folders 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
copy recordset to CSV file 1

Top