Excel 2003 / VS 2005 Automation Add-In

  • Thread starter Thread starter My interest
  • Start date Start date
M

My interest

My computer recently crashed, so I rebuilt it and installed office
2003, VS 2005, PIA for 2003 etc (as it was before). But very
strangely, all my C# based Excel automation add-in stopped working.
In fact I can load them into Excel without any error message, i.e.
Tools / Add-In / Automation / Selec the class, click OK. However as
soon as I close the add-in dialog box and reopen it, all the ticks are
gone. There is no error message in the whole process.

I have tried to recompiled the code etc, without any luck. There is
no error in the event log as well.

I don't think it's related to the code, but more or less related to
some configuration. Can anybody have any hint for me?

Also, is there anyway to turn on Excel logging so I can see what's
going on? (I suspect there is an exception being thrown silently
during the loading / activiating the add-in, but I could not intercept
it by lauching VS debug session.

Thanks.
 
Have a look at your event log see what's up. I'd expect either failed
registrations or dependency issues since you re-isntalled everything. Right?

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
 
Have a look at your event log see what's up. I'd expect either failed
registrations or dependency issues since you re-isntalled everything. Right?

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively onwww.lulu.com/owc$19.99
-------------------------------------------------------
Click to expand...

Nothing in the event log. Actually I can register mannually using
regasm without problem (with or without /codebase). In fact, I can
even refer to that class in VBA code (e.g. COM registratin seems to be
OK)
 
Back
Top