Linking Files that are closed

[simon.stewart]

Hi,
I am trying to link to different files in the same folder. I have wrote

in a cell the name of the file that I want to link to and the used the
formula =INDIRECT("'[" & G5 & "]" & "Data'!B26") which means that
whatever file name I type in G5, the formula will return the value in
cell B26 from that file.

The only problem is that the INDIRECT formula only works when the
filename in question is open. Is there another formula I can use that
does the same job, but can reference closed files? I have about 80
files to reference so obviously don't want to keep them all open!


Thank you.


Simon

 

[Dave Peterson]

Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed
workbook.

You can find the function at Harlan's FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip

Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/

That includes =indirect.ext() that may help you.

Hi,
I am trying to link to different files in the same folder. I have wrote

in a cell the name of the file that I want to link to and the used the
formula =INDIRECT("'[" & G5 & "]" & "Data'!B26") which means that
whatever file name I type in G5, the formula will return the value in
cell B26 from that file.

The only problem is that the INDIRECT formula only works when the
filename in question is open. Is there another formula I can use that
does the same job, but can reference closed files? I have about 80
files to reference so obviously don't want to keep them all open!

Thank you.

Simon

 

[simon.stewart]

Thanks a lot Dave, I will check it out!

Simon

Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed
workbook.

You can find the function at Harlan's FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip

Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/

That includes =indirect.ext() that may help you.

Hi,
I am trying to link to different files in the same folder. I have wrote

in a cell the name of the file that I want to link to and the used the
formula =INDIRECT("'[" & G5 & "]" & "Data'!B26") which means that
whatever file name I type in G5, the formula will return the value in
cell B26 from that file.

The only problem is that the INDIRECT formula only works when the
filename in question is open. Is there another formula I can use that
does the same job, but can reference closed files? I have about 80
files to reference so obviously don't want to keep them all open!

Thank you.

Simon