"Robin Clay" wrote in message
...
Keith Willshaw responded, 7/25/2003 5:48:10 AM
for which, many thanks - it seem just waht I want !

But I'm afraid I have a query -

... use the DIR function
Dim myfile as String, myfilecount as Integer
Dim myfilelist(1000) As String
myfilecount =0
myfile = Dir(mydirectory & "\*.ali", vbNormal) _
' gets first entry
Do While myfile < ""
myfilelist(myfilecount) = _
mydirlist(i) & "\" & myfile
~~~~~~~~~~~~
What is mydirlist ?

A typo, I snipped this excerpt from a piece of code I use, essentially
I iterate through multiple subdirectories rather than just 1
directory. Just replace it with your directory name

What is i ?
Should they be declared ?

All variables should be declared

Keith