View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Cant find library

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.
Ive 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, €śCant 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