Thread
:
Use a cell to name a file to be opened.
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_]
external usenet poster
Posts: 896
Use a cell to name a file to be opened.
e.g.
=INDIRECT('C:\Documents and Settings\[&A1&".xls]Bonds'!$H$6")
where A1=Somefile
will retrieve data from file "Somefile.xls" stored in C:\Documents and
Settings\, from cell H6 in worksheet named "Bonds"
Reply With Quote
Jarek Kujawa[_2_]
View Public Profile
Find all posts by Jarek Kujawa[_2_]
Use a cell to name a file to be opened.