I will have to work on it...............not as adept at VBA as many of the
others here.

All folders contain a workbook named ORF.xls

All ORF workbooks contain a sheet named ORF_Change

We want row 5 from each sheet to accumulate in a new sheet in a workbook.

The code would reside in only that one workbook.

The trick for me is to loop through A1:A223 to get the changing paths and use
Ron's code to pull from a closed workbook.

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

Help! anybody.


Gord

On Thu, 23 Jun 2011 10:10:43 -0700 (PDT), carl wrote:

Ok. I have the list of paths in excel.

So with that list in A1:A223, can you show me the code that will go
into each of these files and extract the 5 row of data ?