Using variable in external links

[automne]

Dear all,

Is is possible to use value store in other cells in external links?
Say I have a list of filename on column A

apple.xls
orange.xls
banana.xls
..... and thousands more.

How can I build external links to these workbooks by formula easily? Like
this for example,
='C:\apple.xls\Sheet1'!$A$4
='C:\orange.xls\Sheet1'!$A$4
='C:\banana.xls\Sheet1'!$A$4

Any help would be highly appreciated.

Thanks & regards,
Automne

 

[Myrna Larson]

See if the INDIRECT function will help.