Excel 2003 / VS 2005 Automation Add-In

[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.

 

[Alvin Bruney [ASP.NET MVP]]

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

 

[My interest]

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
-------------------------------------------------------

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)

 

[Steve K.]

Try one of these boogers:

Update for Office 2003 (KB907417)
http://www.microsoft.com/downloads/...FamilyID=1b0bfb35-c252-43cc-8a2a-6a64d6ac4670

or this one
http://support.microsoft.com/kb/908002/en-us

There was an update that happened adn afterwards one of the two above were
required, I can't remember which one. I do remember going MAD for days
trying to figure it out! ;0)

 

[My interest]

Briliant!! It worked. Thanks very much.