compile error with Mid() function

[jc]

I'm running some code which worked on another pc.

I'm getting: Compile Error: Can't find project or library.
on a Mid() function.

There is a reference on the PC that works in the VBA references called
"Ref Edit Control"

On the PC that it is not woring on it says the "Missing: Ref Edit Control"
it shows the path and file to the DLL but when try to browse to it it still
shows missing.

In Both cases Im running Excel 2003. In the case that works I'm using
Windows XP and the case that doesn't In using Windows 2000.

I'm Assuming Ref Edit Control Missing is causing the Mid() funciton to fail
but am not sure.

How do I get it to work??

 

[JLGWhiz]

Hi jc, in your VB editor, click Tools, References. When the dialog box comes
up, locate the dll and check the checkbox, click OK and then save. It should
run after tthat.

 

[JLGWhiz]

If you still cannot locate it, you might have to go to MS Support and
download it. I believe it is a free download.

 

[Bob Phillips]

Just uncheck that reference.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[jc]

I did that. The file is there but it says " missing in the reference line"

 

[jc]

Why does the mid function depend on this dll. I would think it would be the
VBA reference?

 

[jc]

It appears that I need it to get the "Mid" funtion to work.

 

[Dave Peterson]

A missing reference can cause an error on a line that has nothing to do with
that reference.

 

[Rick Rothstein \(MVP - VB\)]

You did what? Did you put a check mark in the check box next to it and then
click OK? If so, that should have straightened out your problem.

Rick

 

[Bob Phillips]

No, you need it unchecked to get Mid to work.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[jc]

On the computer where the code does work it is checked. It is not checked on
the computere where it doesn't work. but the references shows missing.
previously on the computer that works now it did not work until I checked it
and it stayed checked.