specific compile error

[Robby87]

I get the following error when I run my code:

"Compile error:
User-defined type not defined"

VBA highlights this line of code:
Public msg As New TibrvMsg

I think maybe I'm missing a reference or something in tools/references.

Any recommendations?

Thanks!

 

[VoG]

TibrvMsg isn't recognised in VBA as far as I am aware. What are you trying to do?

 

[Robby87]

I'm editing a macro written by someone else, and I also don't understand what that particular line of code does, but it produces an error that solves the problem.

The only line of code in which the variable again appears is this:
If Not msg.IsValid Then msg.create Else msg.Reset

That statement is in a for...next loop.

Any ideas? I'm thinking there is a quick fix for this because I believe the code runs on other peoples computers.

 

[Richard Schollar]

Go to one of the computers on which this works and verify what references they have set. That should identify if there is one you do not have.

 

[Norie]

Take a look under Tools>References...

Is anything marked as MISSING or is there anything with a similar name to TibrvMsg?

All that line of code does is (try to) declare a variable of the type TibrvMsg.

What is the purpose of the code?

Is it using anything outwith Excel? eg ORACLE, Java?

 

[Robby87]

thanks -- problem resolved.

In order to resolve an earlier problem in the code, I unchecked the missing reference. I looked at an earlier version of the code, found out which reference was missing, and just checked it off in reference.

That solved the problem. much appreciated everyone.