View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2466_] Rick Rothstein \(MVP - VB\)[_2466_] is offline
external usenet poster
 
Posts: 1
Default compile error with Mid() function

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


"jc" wrote in message
...
I did that. The file is there but it says " missing in the reference line"
--
CroceJC


"JLGWhiz" wrote:

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.

"jc" wrote:

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??

--
CroceJC