I have a large number of xls files in a folder and I would like to generate a
list of the contents of a cell (say "B3") in each of the files.

Can I do this without opening each file? One method would be to create a
link to that cell in one file and then a routine to edit the filename and get
the result of the formula for each file, but is there a more elegant way?

Thanks, Kaval