Addin Tied to User Profile?

[Charles Jacobus]

Any help on this would be greatly appreciated. Thanks!

Background: Addin written in VB6 for Microsoft Excel. Works great 99% of the
time.

Problem: One or two customers have experienced this error and the addin no
longer runs: "Unable to load
Application.COMAddins.Item(ADDIN_NAME).object.ADDIN_CLASS", where ADDIN_NAME
and ADDIN_CLASS are substituated with the correct name and class.

Solution: We've had this problem happen internally once. Were able to fix it
by removing the user profile associated with the user experiencing the
problem and then recreate the user profile. (Other users on same machine
continued to work OK.) No reinstall of addin required.

Question: Does anybody know what might be going on here? Any documentation
on how a COM addin could get "corrupted" for one user and not others and/or
what profile-specific information is in the registry that we could look for?

 

[Chango V.]

I have experience only with COM addins for Word, but I think all Office apps
work the same way. Word addins can be registered system-wide or per user:
HKLM\Software\Microsoft\Office\Word\Addins or
HKCU\Software\Microsoft\Office\Word\Addins. Maybe in your case the HKCU
entry is getting corrupt? On Windows XP, a System Restore could do that
[random thought].

//