John,
Here is a link to a previous post of mine in Google that does this using
FileSystemObject.
http://tinyurl.com/km4m
This example goes through the folder looking for Excel workbooks and opens
them
--
HTH
Bob Phillips
"John Acocella" wrote in message
...
I want to retrieve the file names of excel files in a
specific directory, retrieveing them one at a time through
a looping routine. Is there any way to do this in Excel
besides using the DIR function? I thought I read
something in the Microsoft knowledge base, but I can't
find it. Thanks.