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

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.

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

Hi scriptman

Try this
http://www.rondebruin.nl/txtcsv.htm

Or
http://www.rondebruin.nl/csv.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"scriptman" wrote in message ...
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.