Indirect Function
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!! |
Indirect Function
Looks like you are missing the "[" in front of Myfile
"Sandy" wrote: 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!! |
Indirect Function
Thanks for pointing out the typo----but it is still evaluating wth the extra
qoutes instead of just a single qoute. "Duke Carey" wrote: Looks like you are missing the "[" in front of Myfile "Sandy" wrote: 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!! |
All times are GMT +1. The time now is 06:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com