Lost VBA References

[Puertorekinsam]

I have a excel add in built in excel 2013.
Half of my team has 2013, half of my team has 2010...

One of the References I use in the code is: "Microsoft Office 15.0 Object Library" The team members that have office 2013, have no problems. The teammates that have Office 2010, it throws a compile error.
I have found the missing DLL file and given it to the team members who are experiencing the issue. If they point to that file it will work... until they close excel. Once they close and reopen, the reference is lost. I have tried the following:
1) I have had them save the add in after updating the reference,
2) we've added a dummy line of code (x=x) and saved the add in to make sure the save is working
3) I have updated the reference on my machine to point to a copy of the dll on a shared directory and sent that updated add in to them.

No matter what, the reference does not seem to save.

 

[Sektor]

The problem is Office 2013 can resolve the reference to Office 2010, but not otherwise.
You could add the reference programmatically. Change path according to x64 or x86 Office and also you have to tap the following check box: File->Options->Trust Center->Trust Center Settings->Macro Settings->Trust access to the VBA project object model.

Sub AddOfficeRef()
        ThisWorkbook.VBProject.References.AddFromFile Environ$("SystemDrive") & "\Program Files\Common Files\microsoft shared\OFFICE14\MSO.DLL"
End Sub

You can read this.