getting info from multiple workbooks simultaneously

[Alex]

Hi,

I'm trying to write a function that retrieves certain information from
different workbooks all with the same structure.
There are typically several hundred workbooks containing the needed
information and they are not necessarily ordered sequentially.
In Column A of the active workbook will be a list of id numbers which are
also the names of the workbooks, that the data needs to be pulled from, minus
the file extension. I've run out of ideas on how to go about doing this. Any
suggestions would be greatly appreciated.

Thanks,
Alex

[Norman Jones]

Hi Alex,

See Sample code from Ron de Bruin at:

http://www.rondebruin.nl/copy3.htm#Loop

See particularly: Sub Loop_Through_Files_in_Range()

See also:

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

and

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


---
Regards,
Norman



"Alex" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm trying to write a function that retrieves certain information from
> different workbooks all with the same structure.
> There are typically several hundred workbooks containing the needed
> information and they are not necessarily ordered sequentially.
> In Column A of the active workbook will be a list of id numbers which are
> also the names of the workbooks, that the data needs to be pulled from,
> minus
> the file extension. I've run out of ideas on how to go about doing this.
> Any
> suggestions would be greatly appreciated.
>
> Thanks,
> Alex

[Alex]

Hi,

It looks like copy7.htm is the closest to what I'm trying to achieve, the
network drive in particular. Hoewever, I'm not sure exactly what he is doing
there or why especially with the timer, it would appear that he is copying a
block of data from a single sheet.

I need the file path to be constructed from the value in "A2", for example
\\"A2 value"\"A2 value".xls information in those workbooks is contained on
several different sheets and I would like it to populate the cells on the
same row on the same sheet as the column containing the file names. How do I
go about doing this?