I see a cell formula:
="='C:\Temp\[basefilename"&Text(Today(),"yymmdd")&".xls]Sheet1'!$A$1"
but I want to reference one folder as "A23" and the file as "B23".xls. then
when I pull the formula down my column I hope it will change the folder and
file to the values in the A and B columns. still not clear to me :(



"Harlan Grove" wrote:

Ralph wrote...
So the worksheets are not in the same workbook and are saved as individual
files, right? . . .

Look at the OP's sample formula,

=[648455.xls]Sumbit!$L$9

Workbook and worksheet names differ, so the syntax is the same as if
the workbook contained multiple worksheets.

. . . I don't think the indirect function works here. I too am
searching for a way to do this, if you find one let me know and I will do
same.

If the workbook is open, INDIRECT does work for this. It's only when
the other workbook is closed that INDIRECT doesn't work. In that case,
see

http://www.google.com/groups?selm=hk...wsranger.c om