If I use the addin will I be able to give the spread sheet to another person
and have it perform the same on their machine?

"Dave Peterson" wrote:

The function you'd want to use that's built into excel is =indirect(). But that
function returns an error if the sending workbook is closed.

If that's a problem, then Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

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

P Grieshop wrote:

Here is my problem. I want to access external file(s) based on a name in a cell

A1 Example1
A2 =C:\Test\"A1".xls!$a$3

As the above formula stands I want it to open a file with the following
C:\Test\Example1.xls$a$3

If A1 where changed to Example2 then the following would open
C:\Test\Example2.xls$a$3

In short I want the path and file name changeable based on a cell reference.

Thanks in advance for any help you can give me.

--

Dave Peterson