get directory names

[rhino4eva]

I have a very complicated problem that may have a simple solution

I work with a biochemical analyzer which churns out copious amounts of data for quality purposes
The machine outputs a directory structre which I need to explain
the root of the directory is on c:\data\

each day the computer creates a new directory with a different value I think its a date code
each file in that directory has the same date code for a filename with additional number on the end
the number of files is variable

so if the directory was Monday the files inside that directory would be Monday 1.txt Monday 2.txt etc

what I need need is a vba dialogue so I pick which folder to choose and hold that name in a variable

I plan to use that variable in another piece of code I have built

 

[Fluff]

You're welcome & thanks for the feedback