Thank you kind Sir............I went and got the PULL file and will try it
tomorrow........about to fall off my chair tonight...........

Thanks again loads.......

Vaya con Dios,
Chuck, CABGx3



"Dave Peterson" wrote in message
...
You'd want to use the =indirect() worksheet function. But that doesn't
work
with closed files.

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/

CLR wrote:

Hi All........

I am trying to concatenate two cells together to form a filename in a
link............no joy, .......all I get is "That filename is not
valid"........

=[clean(c6)&"_"&b6.xls]Sheet1!$A9

C6 is a name, as Jones, Fred
B6 is a string as R1938

The filename I 'm looking for is Jones,Fred_R1938.xls and it does
exist........and of course works if I hard code the filename into the
formula........

=clean(c6)&"_"&b6 works fine in a test of that standalone part, but not
in
the link formula

Any help would be appreciated........

Vaya con Dios,
Chuck, CABGx3

--

Dave Peterson