compile error with Mid() function

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

"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

's Computer Specifications

Just uncheck that reference.

--
HTH

Bob

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

"jc" <(E-Mail Removed)> wrote in message
news:C49ED4FB-AB28-4DB5-A5C2-(E-Mail Removed)...
> 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

's Computer Specifications

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

's Computer Specifications

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

--
CroceJC

"JLGWhiz" wrote:

> If you still cannot locate it, you might have to go to MS Support and
> download it. I believe it is a free download.
>
> "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

's Computer Specifications

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

--
CroceJC

"Bob Phillips" wrote:

> Just uncheck that reference.
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "jc" <(E-Mail Removed)> wrote in message
> news:C49ED4FB-AB28-4DB5-A5C2-(E-Mail Removed)...
> > 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
>
>
>

's Computer Specifications

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

jc wrote:
>
> Why does the mid function depend on this dll. I would think it would be the
> VBA reference?
>
> --
> CroceJC
>
> "JLGWhiz" wrote:
>
> > If you still cannot locate it, you might have to go to MS Support and
> > download it. I believe it is a free download.
> >
> > "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

--

Dave Peterson

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:91EF6FE8-E738-431E-854B-(E-Mail Removed)...
>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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:A010E14B-E399-4A83-90BF-(E-Mail Removed)...
> It appears that I need it to get the "Mid" funtion to work.
>
> --
> CroceJC
>
>
> "Bob Phillips" wrote:
>
>> Just uncheck that reference.
>>
>> --
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
>> addy)
>>
>> "jc" <(E-Mail Removed)> wrote in message
>> news:C49ED4FB-AB28-4DB5-A5C2-(E-Mail Removed)...
>> > 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
>>
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NZ function compile error	=?Utf-8?B?QXJ0cw==?=	Microsoft Access Queries	1	6th Jun 2007 01:05 PM
Compile error on VBA Function	=?Utf-8?B?TVN3ZWV0RzIyMg==?=	Microsoft Excel Programming	13	3rd Nov 2006 04:09 AM
mid function causes a compile error	Brotherwarren	Microsoft Excel Programming	3	9th Oct 2006 06:21 PM
mid function causes a compile error	Brotherwarren	Microsoft Excel Programming	1	9th Oct 2006 06:06 PM
Compile error: sub or function	=?Utf-8?B?RGVlbm9z?=	Microsoft Access	9	5th Apr 2006 06:03 AM