Indirect Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandy - 20 Mar 2006 18:16 GMT

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!!

Reply to this Message

Duke Carey - 20 Mar 2006 19:41 GMT

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
[quoted text clipped - 11 lines]
> I hope this post wasnt too confusing
> Thanks!!

Reply to this Message

Sandy - 21 Mar 2006 15:41 GMT

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
>
[quoted text clipped - 13 lines]
> > I hope this post wasnt too confusing
> > Thanks!!

Reply to this Message