Excel COM References

[b33fy]

Hi Guys,

Hope someone can assist.
- We have a custom DLL written in C#. The setup exe Registers the Type Library for the DLL on the users PC.
- We also have an Excel Macro Enabled Workbook which references to this TLB file.

The issue I am experiencing is when I create a new Excel Macro Enabled file and add references to the TLB it keeps track of the Version on my local PC. So when I send this to someone else in the organisation if they do not have the exact same version of the TLB it will return with a Missing Reference. I can understand why it does this but not idea in our situation.

Manual Fix
========
For the user, in Excel, if we Remove the Reference then add it back in (pointing to their local version) this fixes it but it has to be done manually.

Question
=======
Is there a way to Remove and Add a Reference in c# code (not VBA code)? Or open to any ideas on how to manage this. Please keep in mind rolling out the new DLL everytime there is a new version and re-registering the type library to everyone is not feasible for our situation.

Thanks

B

 

[b33fy]

Any ideas?
Thanks in advance.

 

[b33fy]

Bump

 

[b33fy]

Bump

 

[b33fy]

Hey Everyone,

Just wondering how do software coys that deploy a new version of an Excel Add-In deploy it. I would think that somehow they would need to update the references in Excel to point to the new versions.

Any info would be greatly appreciated.

Thanks