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
|