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