#REF Error to another Workbook

[plmitche]

I'm using the following formula and I get a #REF! error:

='http://166.112.149.16/as/Shared Documents/Special Projects/Rental Assistance 9_12/[09_12_07_Rental Assistance"&C13&".xls]Sheet1'!$D$21

The red text creates the #REF error. In C13, I have the workbook number that I need the formula to reference. In this example I have the number "10" I could just replace the red text with 10 and it will work. The reason I don't hard code is because I have 240 different workbooks to reference, and I would like to just drag the formula down. Any ideas on why I get the #REF?

Thanks so much for your help!

[BigBas]

=INDIRECT("'http://166.112.149.16/as/Shared Documents/Special Projects/Rental Assistance 9_12/[09_12_07_Rental Assistance"&C13&".xls]Sheet1'!$D$21")

and report back.

Basically, the INDIRECT function is the function that can make this work for you. Just work with the syntax.

[plmitche]

Still get the error, played with the syntax of C13 part. Not sure how Indirect is any different than just pressing = and pasting the file's path?