MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel VBA Problem in excel 2000

  Asked By: Kent    Date: Mar 09    Category: MS Office    Views: 1158

I have a problem regarding vba excel. I have made an vba script on
Excel 2003 and it runs well. This program will be use on excel 2000.
The problem arrive when I tried it on excel 2000. The error message
is The library was not found.



2 Answers Found

Answer #1    Answered By: Evan Jones     Answered On: Mar 09

There is probably more to the error message than that. Please give the full
error message.

In addition, if a "debug" option is offered, select it and show us the
highlighted line of code.

However, you might be able to find it from the VB environment (ALT-F11).

In 2000, go to Tools/References and look at the references that are ticked.
Chances are that one or more of them will say "missing". These need to be
available to Excel before the sheet can be used. There are two options:

- Look down the list of available references to find one that matches the
missing one, but presumably an earlier version. Tick that and then see how
you go.

- If there is no matching unticked reference, then you'll need to install it
from elsewhere. Search with Google and it'll probably lead you to the
needed information.

Answer #2    Answered By: Ethan Bouchard     Answered On: Mar 09

I think technically, the it isn't a Excel 2000 problem.
The problem  is, the library is not found... this can happen regardless
of the version of Excel. The solution is to install the library!
First, make a note of WHICH library is not found, then
Open VBA and Select Tools -> References.
Look for the missing library and select it.
If you don't find it in the list, you may have to do an internet search
(most likely, it's a standard library that microsoft.com will have),
download it, then use Tools -> References to browse to it..

Didn't find what you were looking for? Find more on Excel VBA Problem in excel 2000 Or get search suggestion and latest updates.