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