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.
Ron de Bruin - 22 Feb 2006 16:50 GMT
Hi WannaBeExceller
Try ADO
http://www.rondebruin.nl/ado.htm

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
>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.