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.

Hi WannaBeExceller

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


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


"WannaBeExceller" <[email protected]> wrote in message
news:[email protected]...
>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.

Hi WannaBeExceller

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


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


"WannaBeExceller" <[email protected]> wrote in message
news:[email protected]...
>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.