user-defined type not defined

[justme]

I have two "identical" workbooks being completed by two different people. My email code works in one, but not another. I copied the code from the workbook that works to the workbook that doesn't and I still get the compile error: User-defined type not defined.

Excel help isn't helping. The code stops in the second line below:

Dim FName As String
Dim VBComp As VBComponent (here, this line is hi-lited)
Dim wbnew As Workbook
Dim x As String

Thoughts?

 

[mole999]

are the references installed the same on both machines

this might point the way

 

[justme]

Please explain further. Excel help mentioned references, but I'm not sure where the reference dialog box is?

 

[mikerickson]

VBComponents is a data type that requries the Microsoft Visual Basic for Applications Extensibility library be referenced.
A quick fix would be to use

Dim VBComp As Object

But there may be other problems later, from that same missing library, in which case an Open event that automaticaly opens that reference library may be needed.

 

[mole999]

my work systems 2003 / 2007 often deletes the references for DAO and something else. I'd like to know more about the open event

 

[mole999]

Please explain further. Excel help mentioned references, but I'm not sure where the reference dialog box is?

A number of ways into VBA, i use right click on a tab and then view code, into the VBA window.

Then Tools > references

and see what is listed on both machines

 

[Norie]

Does the code actually use the variable causing the problem?

If all it's meant to do is email then I wouldn't think you would need to use something like VBComponent.

 

[justme]

Thank you Mole9999 & mikerickson-

I checked the references and both computers are the same. I ended up duplicating the good workbook, erasing the information and copying the info from the bad workbook into the good workbook. The code works fine now. Wierd.

 

[justme]

In one part of the code it is sending the original wb to me and in the other part of the code it is sending a new wb to the supervisor which is a selected area of one of the pages in the wb.