Excel 2000 VBA Help File
 

Why are there functions and methods lited in the VBA help file for Excel
2000 that seemingly will not work on Excel 2000? A few examples:

Str
LTrim
RTrim
Trim
Chr

The list goes on and on but these are a few of the ones that are irritating
me right now. Or am I missing a seeting that allows them to work fine on my
Excel 2002 but prevents them from running on Excel 2000? Every time it
encounters one of these functions it says, "Can't find project or library."
The worst part is when I run across a function described in an old book for
Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's the
deal?

I'm just beginning to learn here so please help a novice out.

Excel 2000 VBA Help File
 

This is generally caused by a missing reference in your project rather than
the fact that the functions are available (both Excel 2000 and Excel 2002
use VBA 6 - so they do work in both).

In Excel 2000, go to Tools=References in the VBE and make sure you project
is selected in the project window (one of the elements/components are
highlighted). Then go to Tools=References and you should see one or more
entries shown as MISSING.

You need to unselect these if your project does not use them, or install
them on that machine if it does.

Generally, use as few references as possible and only those you need.

--
Regards,
Tom Ogilvy


"Shawn Shuler" wrote in message
...
Why are there functions and methods lited in the VBA help file for Excel
2000 that seemingly will not work on Excel 2000? A few examples:

Str
LTrim
RTrim
Trim
Chr

The list goes on and on but these are a few of the ones that are
irritating
me right now. Or am I missing a seeting that allows them to work fine on
my
Excel 2002 but prevents them from running on Excel 2000? Every time it
encounters one of these functions it says, "Can't find project or
library."
The worst part is when I run across a function described in an old book
for
Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's
the
deal?

I'm just beginning to learn here so please help a novice out.

Excel 2000 VBA Help File
 

Shawn,

They're not broken, but something else is. What you describe is a typical
symptom of "version flu": you save a file in a later version then try to
open it in an earlier version, and the reference to Word 2002 can't be
resolved because you have Word 2000 on your older machine.

The typical cure for this disease is to go into the VBE and use Tools |
References, then look for missing references and delete them, then add in
subsitute references for those that have gone missing.

HTH,
Bernie
MS Excel MVP

"Shawn Shuler" wrote in message
...
Why are there functions and methods lited in the VBA help file for Excel
2000 that seemingly will not work on Excel 2000? A few examples:

Str
LTrim
RTrim
Trim
Chr

The list goes on and on but these are a few of the ones that are
irritating
me right now. Or am I missing a seeting that allows them to work fine on
my
Excel 2002 but prevents them from running on Excel 2000? Every time it
encounters one of these functions it says, "Can't find project or
library."
The worst part is when I run across a function described in an old book
for
Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's
the
deal?

I'm just beginning to learn here so please help a novice out.

Excel 2000 VBA Help File
 

Thanks for the help, guys. As I said I'm new to this and the true help for
novices is hard to come by. The documentation is weak and books skip a lot
of the basic information. I can understand that they can't cover
everything.

I'll try checking the references.

Thanks.
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Shawn,

They're not broken, but something else is. What you describe is a typical
symptom of "version flu": you save a file in a later version then try to
open it in an earlier version, and the reference to Word 2002 can't be
resolved because you have Word 2000 on your older machine.

The typical cure for this disease is to go into the VBE and use Tools |
References, then look for missing references and delete them, then add in
subsitute references for those that have gone missing.

HTH,
Bernie
MS Excel MVP

"Shawn Shuler" wrote in message
...
Why are there functions and methods lited in the VBA help file for Excel
2000 that seemingly will not work on Excel 2000? A few examples:

Str
LTrim
RTrim
Trim
Chr

The list goes on and on but these are a few of the ones that are
irritating
me right now. Or am I missing a seeting that allows them to work fine
on
my
Excel 2002 but prevents them from running on Excel 2000? Every time it
encounters one of these functions it says, "Can't find project or
library."
The worst part is when I run across a function described in an old book
for
Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's
the
deal?

I'm just beginning to learn here so please help a novice out.