software

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(quot;Filenamequot;,A1),FIND(quot;-quot;,CELL(quot;filenamequot;,A1)) 1)
and evalutes to c:\Mypath\Myfile - (with spaces before and after -)
In AG3 quot;Expenses 2005quot;
When using fx to step through the formula
=INDIRECT(quot;'quot;amp;AJ5amp;AG3amp;quot;.xls]Sheet1'!$AG$7quot;) AJ58 evaluates to
'''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 (Unsure if they are
double quotes or singles) and =INDIRECT(amp;AJ5amp;AG3amp;quot;.xls]Sheet1'!$AG$7quot;)
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!!

Looks like you are missing the quot;[quot; in front of Myfile

quot;Sandyquot; wrote:

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

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

quot;Duke Careyquot; wrote:

gt; Looks like you are missing the quot;[quot; in front of Myfile
gt;
gt; quot;Sandyquot; wrote:
gt;
gt; gt; Hello
gt; gt; I understand that a full path is not necessary for a reference, but for
gt; gt; discussion and illustration, say it does...
gt; gt; In AJ5 =LEFT(CELL(quot;Filenamequot;,A1),FIND(quot;-quot;,CELL(quot;filenamequot;,A1)) 1)
gt; gt; and evalutes to c:\Mypath\Myfile - (with spaces before and after -)
gt; gt; In AG3 quot;Expenses 2005quot;
gt; gt; When using fx to step through the formula
gt; gt; =INDIRECT(quot;'quot;amp;AJ5amp;AG3amp;quot;.xls]Sheet1'!$AG$7quot;) AJ58 evaluates to
gt; gt; '''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7 (Unsure if they are
gt; gt; double quotes or singles) and =INDIRECT(amp;AJ5amp;AG3amp;quot;.xls]Sheet1'!$AG$7quot;)
gt; gt; evaluates to ''c:\Mypath\Myfile - Expenses 2005.xls]Sheet1'!$AG$7. I am
gt; gt; trying to get the evaluation to be 'C:\Mypath\Myfile - Expenses
gt; gt; 2005.xls]Sheet1'!$AG$7 as a valid reference.
gt; gt; I hope this post wasnt too confusing
gt; gt; Thanks!!