I am using the Dir function to iterate thru a directory for files with a
certain name as follows, there will be more than one file that meets the
mask

Dim myFiles
myFiles = Dir("C:\"Export_List*.xls")
Do While myFiles < ""
myFiles = Dir
Loop

My question

How do I store all the file names found into an array?



--
Cheers
Nigel