S
Sam
Here is the detail of my problem:
$A$1 is the directory where the external excel files are, like
C:/temp/data/;
B1:B1000 are the excel files names without the .xls extension, like
File001 to File1000;
C1:C1000 where I want to link to the same cell in the corresponding
files FILE001~1000.xls.
In order to make the link to an external workbook, I need to use the
concatendate() function to provide a link, combining the file diretory
$A$1, filename B1, ".xls", worksheetname and cell reference, something
like 'C:/temp/data/[File001.xls]Sheet1'!$F$1. But concatendate() only
returns the text, not the value of the text. So how can I use the
value of text, not the text of text?
Any suggestions will be welcomed.
Thanks a lot in advance.
$A$1 is the directory where the external excel files are, like
C:/temp/data/;
B1:B1000 are the excel files names without the .xls extension, like
File001 to File1000;
C1:C1000 where I want to link to the same cell in the corresponding
files FILE001~1000.xls.
In order to make the link to an external workbook, I need to use the
concatendate() function to provide a link, combining the file diretory
$A$1, filename B1, ".xls", worksheetname and cell reference, something
like 'C:/temp/data/[File001.xls]Sheet1'!$F$1. But concatendate() only
returns the text, not the value of the text. So how can I use the
value of text, not the text of text?
Any suggestions will be welcomed.
Thanks a lot in advance.