Reading from a closed workbook
 

I was wondering if there is a way to read from different excell workbooks
that are closed. I am trying to read data from different workbooks do some
calculations and then store the values in my current workbook that is open.
If I open all the workbooks, I run out of memory. I figured the way around it
is to read the files while they are closed. Please help. Thanks in advance.

Reading from a closed workbook
 

Hi WannaBeExceller

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"WannaBeExceller" wrote in message
...
I was wondering if there is a way to read from different excell workbooks
that are closed. I am trying to read data from different workbooks do some
calculations and then store the values in my current workbook that is open.
If I open all the workbooks, I run out of memory. I figured the way around it
is to read the files while they are closed. Please help. Thanks in advance.