User select folder name

[MJKelly]

Hi,

I have a number of csv files which I import into a spreadsheet. This
all works fine, but I have hardcoded the name of the folder which
contains the csv files. How can I share this spreadsheet with my
colleagues and allow then to put their CVs files anywhere on their
system, and simply have excel use the open file dialogue to let them
navigate to the correct folder? I don't want them to have to select
the files (as there will be many csv and other files in the folder).
I just want to capture the path of the folder they choose and have
excel use this to import the csv files.

Thanks,
Matt

 

[Ron de Bruin]

Hi MJKelly

See example 2
http://www.rondebruin.nl/csv.htm