This is a puzzle.
I’ve used the Mid and mid$ functions a lot,
The VBE6.DLL object library is loaded,

And the following text fails on the mid() function.
The compile error says, “Can’t find project or library�


Sub test1()

Dim a As String
Dim b As String

a = "ABCDEFGHI"
b = Mid(a, 3, 3)

End Sub

What is happening here?

keith

Could you please check the location of the first reference"Visual Basic for
Applications" that is checked in the References dialog box

If this post helps click Yes
---------------
Jacob Skaria


"keith" wrote:

> This is a puzzle.
> I’ve used the Mid and mid$ functions a lot,
> The VBE6.DLL object library is loaded,
>
> And the following text fails on the mid() function.
> The compile error says, “Can’t find project or library�
>
>
> Sub test1()
>
> Dim a As String
> Dim b As String
>
> a = "ABCDEFGHI"
> b = Mid(a, 3, 3)
>
> End Sub
>
> What is happening here?
>
> keith
>

Hi Jacob,
Thank you.

The problem is solved. It happened when I load a copy onto an older
computer and earlier version of Office.

Keith