Getting data from unopened spreadsheet
 

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

Getting data from unopened spreadsheet
 

Hi Kaval,

Ron de Bruin has some sample code at;

http://www.rondebruin.nl/ado.htm


---
Regards,
Norman



"Kaval" wrote in message
...
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