Concatenate a formula

[Steven]

="'C:\Accounting\Files\[" &H5& ".xls]Sheet1'!$I$6"

Will return this in the cell.

C:\Accounting\Files\[Accounting1.xls]Sheet1'!$I$6

But not the value of the cell I6 which is what I want.

Thank you,

Steven

 

[Max]

Think you need to use INDIRECT to resolve the link formula that you have
strung up, viz indicatively: =INDIRECT(<your concat string>)

But INDIRECT won't work on closed source files which is what your "link
formula" suggests that you're trying to do. It'll work on open source files,
or across sheets in the same book.

For updating from closed source files, I'd just normal link formulas, and
adjust these as necessary via Edit>Replace's.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik