Using the Indirect function with links

[Parkerl]

Hi, I was wandering if anyone could help me.....

I'm trying to create a 'dynamic' link which will link to differen
files depending on the contents of a certain cell.

For example, if cell A1 contains the date 21/09/2004, then I need cel
B1 to link to the file

C:\My Documents\2004_09_21\data.xls cell P27
I know that without using links, you can construct something like:

Cell A1 = P
Cell A2 = 27
Cell A3 = indirect(A1&A2)

and this will make A3 be equal to P27

But when you try it with links e.g.


Cell A1 = '\\c:\My Documents\[Data.xls]Sheet 1'!
Cell A2 = P27
Cell A3 = indirect(A1&A2)

This doesn't work! Can anyone please help?!

Thanks very much
Luk

 

[Frank Kabel]

Hi
INDIRECT won't work with closed files. See the following
thread for some alternatives:
http://tinyurl.com/2c62u