HELP: compile error message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KevinGPO - 23 Nov 2005 16:48 GMT

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?

Reply to this Message

Tony Jollans - 23 Nov 2005 18:03 GMT

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.

--
Enjoy,
Tony

> This is referring to the Office Excel VB. Excel VB claims it is just like
> VB.
[quoted text clipped - 7 lines]
> "Compile error: Can't find project or library" and it highlights Left(
> function line?

Reply to this Message