HELP: compile error message

[KevinGPO]

This is referring to the Office Excel VB. Excel VB claims it is just like
VB.

I am wondering where on the internet how I can find out whether a function
existed for a particular version of Office Excel VB?

For example, I am using Office 2003 but my clients are using Office 95, or
97. Am wondering whether the string function Left() & Right() existed in
Office 95/97 Excel VB? If so, then does anyone have any ideas why VB threw a
"Compile error: Can't find project or library" and it highlights Left(
function line?

 

[Tony Jollans]

This is a Word newsgroup, but the reason is likely the same.

The usual reason for functions like Left and Right doing this is a missing
reference higher up the search chain.

In the VBE, select Tools > References form the Menu and see if any of the
checked libraries is preceded by "MISSING". If so, you'll need to determine
whether it is needed and decide what to do about it - the most common reason
is that the computer is using a different version of some software from that
used on the original machine and all you'll need to do is find the
appropriate version library in the list.