Reading Contents of a Directory

[Nigel]

Hi All
I need to fill a set of combo boxes with a list of files from separate
directories. No problem with filling a combo box but what is the best
method of reading a directory contents. I will be looking for .xls file
types with a text mask for the filename. e.g. all files beginning "ARTS_"
and ending ".XLS"

TIA

 

[Guest]

Look in VBA help at the Dir function

 

[Nigel]

Thanks, I found a solution ......

FDir = "C:\directory\"
Fname = Dir(FDir, 7)
Do While Fname <> ""
' code to fill combo here
Fname = Dir
Loop