View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
iop iop is offline
external usenet poster
 
Posts: 9
Default 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