how do i get data from another workbook

[pfunkerausa]

is there a way to get data from another workbook by having the file named
from a cell? ex: have a cells w/ file name which should refer to the file i
want to pull the data from.
abc & xyz are file names and data in cells. abc is in cell G1 and xyz is in
cell H1. I want to create a formula that will call upon the files
[abc.xls]data!a1 or [xyz.xls]data!a1 by refering to the cell G1 or H1
I've already tried to get the data this way: =[(G1).xls]data!a1 for my
abc data
Is there a way to do this???

 

[T. Valko]

Is there a way to do this???

Using only the built in functions, yes, *BUT* the source files *MUST BE
OPEN*.

That is usually enough to ruin your idea!

However, there is an add-in available that has a function that can do this
without the source files needing to be open:

http://xcell05.free.fr/english/

Look for the add-in MOREFUNC.XLL

The function you want is INDIRECT.EXT

Biff

 

[pfunkerausa]

Thanks for responding. I downloaded the suggested, but it still seems to be
the same as what the software is already capable.

I'm trying to get the formula to call upon the text from a cell in the
current workbook. This text is the name of the file from where I want the
data to come from. My current version looks like this:

=IF('C:\My Documents\Stocks\[ORCL.xls]Data'!R5<>"",'C:\My
Documents\Stocks\[ORCL.xls]Data'!R5,"")

Which works fine, but I need a template to where the file name ORCL can be
changed by just changing the cell that is being called.
Something like: =F2 where F2 has my text ORCL, and now I want to change the
F2 text to MSFT
I need the formulas to update according to what is in the cell.
=IF('C:\My Documents\Stocks\[(F2text).xls]Data'!R5<>"",'C:\My
Documents\Stocks\[(F2text).xls]Data'!R5,"")

Thanks again for your time!!

pfunkerausa

Is there a way to do this???

Using only the built in functions, yes, *BUT* the source files *MUST BE
OPEN*.

That is usually enough to ruin your idea!

However, there is an add-in available that has a function that can do this
without the source files needing to be open:

http://xcell05.free.fr/english/

Look for the add-in MOREFUNC.XLL

The function you want is INDIRECT.EXT

Biff

is there a way to get data from another workbook by having the file named
from a cell? ex: have a cells w/ file name which should refer to the
file i
want to pull the data from.
abc & xyz are file names and data in cells. abc is in cell G1 and xyz is
in
cell H1. I want to create a formula that will call upon the files
[abc.xls]data!a1 or [xyz.xls]data!a1 by refering to the cell G1 or H1
I've already tried to get the data this way: =[(G1).xls]data!a1 for my
abc data
Is there a way to do this???