R
Rock
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
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