MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Library not found

  Asked By: Ken    Date: Mar 18    Category: MS Office    Views: 1798

I use the LEFT function in my VBA code to grab part of a string. It
works fine on my machine but the function will not work on other
machines in my office. When I try to invoke the procedure that calls
the LEFT function I get the error message:

"Complie Error. Cannot find Project or Library."

The object browser shows the function to be part of VBE6.dll which is
on the other machines.

What's wrong?



2 Answers Found

Answer #1    Answered By: Kristen Chavez     Answered On: Mar 18

With all the experts in this forum I expected somebody to help me with
my problem. No one has so far. My code, which uses string  functions
like LEFT cannot run on other people's machines in my office.

I finally found  a solution -- I simply changed "Left" to
"Strings.Left" and the code  worked.

Now maybe someone can explain why my machine  knows that Left is part
of VBA.Strings and the other machines in the office  have to be told
specifically that Left is found in Strings?

Answer #2    Answered By: Jennie Harris     Answered On: Mar 18

I would think there could be any of a number of causes. You would need to
look at:

What version of Excel and any other VB programs was on each machine
If it had been properly installed, including being registered
What libraries were shown as references in the VB editor on each machine
If the application was distributed as compiled, whether the runtime libraries
on the target machines were compatible (Applicable only if it was not
distributed as an excel file)
If the registry entries were complete

If none of those enquiries produced anything useful you could try entering the
VBA code  on the target machines and see if it compiled there without errors.

You could look at the help files on the target machines and see if they make
any comments about the strings library.

I hope you understand that because we do not know what you are doing and what
the setup is on your PC and the target PCs it is not practical for us to do
this sort of troubleshooting.

Didn't find what you were looking for? Find more on Library not found Or get search suggestion and latest updates.