See this previous discussion. Particularly the function by KeepItCool:

http://tinyurl.com/8ybkh

--
Regards,
Tom Ogilvy

"Rock" wrote in message
oups.com...
I am trying to compile lots of data from hundreds of XLS files. The
sheet names containing the data are not the same; however, there are
some distingishing features that I can check. I have been using
formulas to refer to cells in a sheet so I don't have to open every XLS
file to get the data.

Is there any way I can get the names of the worksheets of the unopened
file so I can use the sheet names in a formula and then test that
value?

Thanks for the help.

Rock