I have an colleague that has made a reference to a type library. The type
library was originally written in C# and does a number of "fancy" things.
Unfortunately, he has added this reference after improving the type library
several times using the same name to his Excel file. This results in the
"references" box containing four items with the exact same name, but
referencing 4 different versions of the same library. Neat.

Is there a way to remove a reference from the reference list permanently?
And/or is there a good way to fix this situation assuming the need for the
type library cannot be changed?

Thanks!

Mark

Hi Mark,

The Excel will retrieve the information from registry.
It is commonly under the key below.
HKEY_CLASSES_ROOT\TypeLib

You may try to edit it with regedit.
WARNING: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system. Microsoft
cannot guarantee that you can solve problems that result from using
Registry Editor incorrectly. Use Registry Editor at your own risk.

Common the COM develop will give your an approach to unregister the COM
library information.

So I highly recommend your contact the developer directly to request for
the information about what his type lib has done with registry.


Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.