On Jun 22, 2:45*pm, carl wrote:
On Jun 22, 2:18*pm, Don Guillett wrote:









On Jun 22, 12:14*pm, carl wrote:

On Jun 22, 1:01*pm, Don Guillett wrote:

On Jun 22, 9:46*am, carl wrote:

On Jun 22, 9:08*am, Gord Dibben wrote:

In that case have a look at Ron's code here.

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

Gord

On Wed, 22 Jun 2011 05:40:30 -0700 (PDT), carl wrote:
Each workbook contains 1 worksheet. I need to extract the 5th row of
the worksheet.- Hide quoted text -

- Show quoted text -

Thanks. I looked at my path again. Turns out the workbooks are all
located in separate folders.

The code you pointed me too looks like I need to select all the
workbooks before running it - is that correct ?

You would need to fully qualify each folder path for each file. You
could, if NOT too many, even use a formula- Hide quoted text -

- Show quoted text -

Thanks. Unfortunately, there are 223

More info perhaps. You have 223 files in ________(how many) folders
and do you know the files in each folder and the sheet in the file to
get the row????????????????- Hide quoted text -

- Show quoted text -

Thanks for helping.

I have 223 files in 223 folders. Each folder only contains 1 file. All
the files have the same name. Each file (workbook) contains 1 sheet
named "ORF_Charge". In this sheet, the data I am trying to extract is
in row 5.

Might I also suggest that you rename the files to include an
identifier such as the folder name
myfilefolder.xls
or similar. Then put all in ONE folder and then loop thru all files in
that folder.