Thanks Dave.........yeah, I finally did that but still no joy...........it
don't give error messages any more, but it also don't give
results........depending on what I type in the =PULL(), I usually get
#VALUE! or #REF!..........I've tried on both 97 and 2000.........I've even
got both May 05 updates and still cant seem to get it to work.......I guess
maybe it's time to start back at square one..............some days the
Dragon wins........

Vaya con Dios,
Chuck, CABGx3




"Dave Peterson" wrote in message
...
You'll have to do the same kind of thing.

n = InStrRev(Len(xref), xref, "!")
becomes
n = InStrRev97(expr, "!")




CLR wrote:

Thanks Dave.........it got past that line by following your
instructions, but
now stops on

n = InStrRev(Len(xref), xref, "!")

I tried modifying it, but no joy.....I'm just shooting in the dark.

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote:

Instrrev was added in xl2k.

You could create your own InstrRev97 function and use that:

Function InStrRev97(mystr As Variant, mydelim As String) As Long
Dim i As Long
InStrRev97 = 0
For i = Len(mystr) To 1 Step -1
If Mid(mystr, i, 1) = mydelim Then
InStrRev97 = i
Exit Function
End If
Next i
End Function

(Just add this to the bottom of that general module.

so
n = InStrRev(Len(expr), expr, "\")
becomes
n = InStrRev97(expr, "\")



=====
There are some other functions that were added in xl2k (split for
example). But
I took a cursory glance at Harlan's code and didn't see any others
that would
cause you trouble.

(Post back when you see that I missed one!)

CLR wrote:

I went after Harlan's UDF and got it but can't for the life of me
figure out
how to use it.
I pasted it into a regular module and, all I can get "Sub or
function not
defined" on this line..

n = InStrRev(Len(expr), expr, "\")

Anybody see what I'm doing wrong?

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson