In 2003

DataImport External DataImport Data

Files Of TypeExcel Files.

Drill down to the folder containing your workbook with the named range and click
OK

You will be presented with "Select Table"

Find your named range and OK

I believe quite similar in 2007 but not tested.


Gord Dibben MS Excel MVP


On Fri, 29 Apr 2011 19:21:05 -0700 (PDT), kittronald
wrote:

Garry,

Thanks for the quick response.

I tried that, but it doesn't bring in the whole named range - just
the first cell.

If you can import a text file, why not a named range in an Excel
worksheet ?

When you import a text file, you get all the rows and columns from
the text file and can also fill down adjacent formulas in the
destination workbook.

Just haven't figured out how to import data from an Excel workbook.


- Ronald K.