Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to refer to tab names? | Excel Discussion (Misc queries) | |||
some kind of meta-way to refer to sheet and file names in Excel? | Excel Discussion (Misc queries) | |||
How to refer to programmatically Dynamice Range names | Excel Programming | |||
Can Names refer to Collections? | Excel Programming | |||
excel calculate problem, (try to refer to defined names?) | Excel Programming |