Deploying Excel Com Addin Problems again

[jens]

Hello,
i v got similar Problems with deploying a managed Com AddIn for Excel 2003
as listed below, but all given advises didn't work here.
As usual the AddIn works fine on the development machine.
After the running the setup on the client i registered the assembly with
regasm.exe.
And after that all registration keys seems to be like they should
(according to literature).
But the AddIn is not loaded . If i try to include it by hand -over the
com-AddIn dialog. i get the message
"<path of Addin > is no valid Office AddIn".
What 'usually' cause this message ?
How can i get more speakable error messages?
Jens

 

[XL-Dennis]

Jens,

Managed COM add-in are difficult to handle for various reasons. In general
You should shim the DLL before distributing it. This refer to the fact that
all COMs use the mscoree.dll as a 'proxy' to be accessible for Excel.

For more info about the COM Shim Wizard 2.0 please see:
http://msdn.microsoft.com/office/de...dc_vsto2005_ta/html/Office2003ShimWizard2.asp

If You open Excel and select the command Help | About Microsoft Excel |
Disabled Items... do You see the add-in in the dialog?

The above does not explicit guide You in view of Your questions but it give
You a better position to handle the creating and deploying the add-in.

Kind regards,
Dennis

 

[XL-Dennis]

I just realized that the following article may be of interest:

Add-ins, smart documents, or smart tags that you create by using Microsoft
Visual Studio 2005 do not run in Office:
http://support.microsoft.com/kb/908002/en-us

Kind regards,
Dennis

 

[jens]

HI Dennis,
thanks for fast replay.
The AddIn did not appear under disabled Items.
I worked with the hotfix 908002 but there was no change.
I know about the mscoree.dll issue. But it seemed more usable for me take
that disadvantages instead developing a shim.
Although the wizard you showed me looks quite 'comfortable' So i think i
will try to work with it.
On the other hand i would like to stop wondering why the addin is not
running with mscoree proxy ...
best regards
jens

 

[XL-Dennis]

Jens,

thanks for fast replay.

You're welcome.

The AddIn did not appear under disabled Items.
I worked with the hotfix 908002 but there was no change.
I know about the mscoree.dll issue. But it seemed more usable for me take
that disadvantages instead developing a shim.

Yes, if You implement it in an enviroment where there exist no more managed
COM add-ins then I can't see any disadvantages for it.

On the other hand i would like to stop wondering why the addin is not
running with mscoree proxy ...

If You like You can e-mail the project to me and I can have a closer look
into it.

Kind regards,
Dennis

 

[jens]

HI Denis,
i did it .
I tried the installation of my Add In on another client with fresh installed
Excel.
And it worked. Even without any regasm calls after (probably thanks to the
908002 Hotfix).
Then i made a repair Excel setup on the 'ill' Client and it worked too.
Goin ahead with shim wizard now.
thanks jens

 

[XL-Dennis]

Great - Good luck with the shimming!

Kind regards,
Dennis