look at the help example for the dir command or use the filesearch object.

--
Regards,
Tom Ogilvy

"dfrancefort" wrote in message
...
I need to get a list of excel files from a directory so
that I can open them one at a time to get information out
of them. I will also need to figure the names of the
worksheets in the files, as each worksheet will have the
same info that I need. Any help would be appreciated!!!