how to refer to the files with regular names? (with formula)
 

e.g. there r some files with regular names: d:\ABC\1.xls, 2.xls, 3.xls, ....
N.xls
i want to refer to some cells of these files in a excel file ( d:\temp.xls),
how to use the formula to make it?

thanks!
--
cj

how to refer to the files with regular names? (with formula)
 

You can create names referencing external ranges e.g.

Names.Add Name:="myName", RefersTo:="=D:\ABC\[1.xls]Sheet1'!$A$1"

Then refer to these in formula e.g.

=A1 * myName

--

Regards,
Nigel




"iop" wrote in message
...
e.g. there r some files with regular names: d:\ABC\1.xls, 2.xls, 3.xls,
....
N.xls
i want to refer to some cells of these files in a excel file (
d:\temp.xls),
how to use the formula to make it?

thanks!
--
cj

how to refer to the files with regular names? (with formula)
 

can we make it directly (without using any macro, only formula)?
thanks!
--
cj


"Nigel" wrote:

You can create names referencing external ranges e.g.

Names.Add Name:="myName", RefersTo:="=D:\ABC\[1.xls]Sheet1'!$A$1"

Then refer to these in formula e.g.

=A1 * myName

--

Regards,
Nigel




"iop" wrote in message
...
e.g. there r some files with regular names: d:\ABC\1.xls, 2.xls, 3.xls,
....
N.xls
i want to refer to some cells of these files in a excel file (
d:\temp.xls),
how to use the formula to make it?

thanks!
--
cj