I have a some xlsx files located he J:\Projects\ORF.

Is there a way to extract the 5th row of each file at this location ?

Workbooks(files) don't have rows.

Each workbook is comprised of one or more worksheets............these worksheets
have rows.

You must be more specific with your description.

But yes..............you can extract data from each of the files(workbooks) in
that folder if you know which worksheet contains the required row.

Check out Ron de Bruin's site.

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

Browse through the codes you find under his Copy/Paste/Merge Examples.

Note the "merge data from all workbooks in a folder"

Ron has also supplied an Add-in you could download.


Gord Dibben MS Excel MVP

On Tue, 21 Jun 2011 12:26:38 -0700 (PDT), carl wrote:

I have a some xlsx files located he J:\Projects\ORF.

Is there a way to extract the 5th row of each file at this location ?

On Jun 21, 7:33*pm, Gord Dibben wrote:
Workbooks(files) don't have rows.

Each workbook is comprised of one or more worksheets............these worksheets
have rows.

You must be more specific with your description.

But yes..............you can extract data from each of the files(workbooks) in
that folder if you know which worksheet contains the required row.

Check out Ron de Bruin's site.

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

Browse through the codes you find under his Copy/Paste/Merge Examples.

Note the "merge data from all workbooks in a folder"

Ron has also supplied an Add-in you could download.

Gord Dibben * * MS Excel MVP



On Tue, 21 Jun 2011 12:26:38 -0700 (PDT), carl wrote:
I have a some xlsx files located he *J:\Projects\ORF.

Is there a way to extract the 5th row of each file at this location ?- Hide quoted text -

- Show quoted text -

Each workbook contains 1 worksheet. I need to extract the 5th row of
the worksheet.

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.

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 ?

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