Is it possible to import a named range from another workbook like
you would import a text file ?

In Workbook1.xlsb there is a named range called DATA that
references A1:C10.

I'm trying to import the data from that named range into
Workbook2.xlsb and keep that connection linked.

Any ideas ?



- Ronald K.

kittronald formulated on Friday :
Is it possible to import a named range from another workbook like
you would import a text file ?

In Workbook1.xlsb there is a named range called DATA that
references A1:C10.

I'm trying to import the data from that named range into
Workbook2.xlsb and keep that connection linked.

Any ideas ?



- Ronald K.

Try a cell formula...

=Workbook1.xlsb!DATA
..if a workbook level name

=[Workbook1.xlsb]Sheet1!DATA
..if a sheet level name

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

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.

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.

It happens that Gord Dibben formulated :
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

Thanks, Gord! Didn't know this because I've never 'Imported External
Data' from anything other than a database. For anything else I always
use ADO. -Didn't think that's the solution the OP wanted.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

try to array-enter the formula i.e. with CTRL+SHIFT+ENTER

HIH

On 30 Kwi, 04:21, 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.