ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cant find library (https://www.excelbanter.com/excel-programming/427180-can%E2%80%99t-find-library.html)

Keith

Cant find library
 
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


Jacob Skaria

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


Keith

Cant find library
 
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




All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com