Using variable in external links
 

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

See if the INDIRECT function will help.


On Sat, 5 Mar 2005 01:48:58 +0800, "automne"
wrote:

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