Indirect Function

[Guest]

Hello
I understand that a full path is not necessary for a reference, but for
discussion and illustration, say it does...
In AJ5 =LEFT(CELL("Filename",A1),FIND("-",CELL("filename",A1))+1)
and evalutes to c:\Mypath\Myfile - (with spaces before and after -)
In AG3 "Expenses 2005"
When using fx to step through the formula
=INDIRECT("'"&AJ5&AG3&".xls]Sheet1'!$AG$7") AJ58 evaluates to
'''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 (Unsure if they are
double quotes or singles) and =INDIRECT(&AJ5&AG3&".xls]Sheet1'!$AG$7")
evaluates to ''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7. I am
trying to get the evaluation to be 'C:\Mypath\Myfile - Expenses
2005.xls]Sheet1'!$AG$7 as a valid reference.
I hope this post wasnt too confusing
Thanks!!

 

[Guest]

Looks like you are missing the "[" in front of Myfile

 

[Guest]

Thanks for pointing out the typo----but it is still evaluating wth the extra
qoutes instead of just a single qoute.

Looks like you are missing the "[" in front of Myfile

Hello
I understand that a full path is not necessary for a reference, but for
discussion and illustration, say it does...
In AJ5 =LEFT(CELL("Filename",A1),FIND("-",CELL("filename",A1))+1)
and evalutes to c:\Mypath\Myfile - (with spaces before and after -)
In AG3 "Expenses 2005"
When using fx to step through the formula
=INDIRECT("'"&AJ5&AG3&".xls]Sheet1'!$AG$7") AJ58 evaluates to
'''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 (Unsure if they are
double quotes or singles) and =INDIRECT(&AJ5&AG3&".xls]Sheet1'!$AG$7")
evaluates to ''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7. I am
trying to get the evaluation to be 'C:\Mypath\Myfile - Expenses
2005.xls]Sheet1'!$AG$7 as a valid reference.
I hope this post wasnt too confusing
Thanks!!