Urgent! VBA complier can't recognize function such as left(), righ

[doniy]

Hello,

today I opened my MS-project, and run a Micro which runs well before.
I got a error message:
Compile error:
Can't find project or library.

and the code window is opened, the fuction Left(....) is highted.
then I tried some other function like mid(), right(), I got the same error.

What is the problem, who to solve it?

thanks in advance.

 

[JackD]

Looks like you are missing the reference to the "Visual Basic for
Applications"
Hit ALT+F11 to open the Visual Basic Editor, then look at tools/references
and see what is checked.
Those functions are in the VBA library.

-Jack Dahlgren

 

[doniy]

Thanks JackD.
You lead me to the right place - references, "Visual Basic for Applications"
is checked, but I found a item "missing ....", it's something from SAP, I
don't know why it is there, so I just unchecked it.
now the micro runs.

thanks again.

 

[JackD]

Glad to be of help.

-Jack Dahlgren

Thanks JackD.
You lead me to the right place - references, "Visual Basic for
Applications"
is checked, but I found a item "missing ....", it's something from SAP, I
don't know why it is there, so I just unchecked it.
now the micro runs.

thanks again.

 

[Steve Goodhall]

What frequently happens in VBA is that if any reference is broken, the
compiler will stop there and will not look beyond that reference for
functions in other dll's. The most frequent symptom is exactly what you see,
a failure on something basic like mid() or right().