software

I have 32 workbooks each containing 24 worksheets. I need to call up data
from the second sheet in each workbook, each of these sheets has a different
name from the others. Is there any way that I can call up the data without
having to give each of the 32 different names, in all cases the worksheet is
the second sheet in each workbook.

ThanksDave Glynn

Sheets within a workbook can be reference by their index number i.e.
Sheets(2) but I can't see a way of letting the system know anything about the
workbook names, unless they were all sequentially named like wb01.xls,
wb02.xls etc. Then it would be feasible to create a loop and open each in
turn to extract the data

quot;dave glynnquot; wrote:

gt; I have 32 workbooks each containing 24 worksheets. I need to call up data
gt; from the second sheet in each workbook, each of these sheets has a different
gt; name from the others. Is there any way that I can call up the data without
gt; having to give each of the 32 different names, in all cases the worksheet is
gt; the second sheet in each workbook.
gt;
gt; Thanks
gt;
gt;
gt; Dave Glynn