As long as DataSource.xls is open, you could use:
=indirect("'[DataSource.xls]" & b1 & ".ABC'!$C$2")

=indirect() won't work if the "sending" workbook is closed.


Eric wrote:

='[DataSource.xls]6227.ABC'!$C$2, which work in cell A1, but
I would like to retrieve the value 6227 from cell B1 for this statement
instead of manually input the value 6227 into the string.
Does anyone have any suggestion?
Thank you in advance
Eric

--

Dave Peterson