Can’t find library

  • Thread starter Thread starter keith
  • Start date Start date
K

keith

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver and 64 bit 1
Find Total and insert one blank row below 4
Change Gradient Fill Colors of Bar Chart data points 1
TransferSpreadsheet and NamedRange; not working! 2
Code Fails to open UserForm 2
select multiple named ranges with macro 4
For Each Subtotal/Bold, Add xlDouble 3
Excel to Schedule Task in Outlook 3

Back
Top