Trouble getting a COM Add-in to load on a machine without VS-2005

[Carlos Valdivia]

I'm new to developing managed (C#) Add-ins for Excel and new to Visual Studio
2005 and very new to developing Add-ins in VS-2005.

That said I've been trying to put together a little test case COM Add-in.
I've followed the basic recipe as as detailed in ".Net Development for
Microsoft Office" using Visual Studio and have gotten a simple COM add-in to
work in Excel 2003 on my computer without a hitch. When I try to send said
add-in to others it doesn't load up for them (though it should). Furthermore
when they check their Excel instance's COM Add-in dialog, they see that Excel
attempted to load the addin but failed (Location "mscoree.dll", message "Not
Loaded, Runtime error occured during the loading of the COM add-in"). This is
strange though because (1) it works without a hitch on my machine and (2) the
first thing to execute in the program is a MessageBox.Show in the Connect
constructor.

Given the MessageBox and my previous experience with developing in VS2005
(with C++), my suspiscion is that there is some dll that should be deployed
that isn't done so automatically. Any thoughts on what the problem is? What
am I missing?

Please help...

 

[Ken Wilson]

I'm new to developing managed (C#) Add-ins for Excel and new to Visual Studio
2005 and very new to developing Add-ins in VS-2005.

That said I've been trying to put together a little test case COM Add-in.
I've followed the basic recipe as as detailed in ".Net Development for
Microsoft Office" using Visual Studio and have gotten a simple COM add-in to
work in Excel 2003 on my computer without a hitch. When I try to send said
add-in to others it doesn't load up for them (though it should). Furthermore
when they check their Excel instance's COM Add-in dialog, they see that Excel
attempted to load the addin but failed (Location "mscoree.dll", message "Not
Loaded, Runtime error occured during the loading of the COM add-in"). This is
strange though because (1) it works without a hitch on my machine and (2) the
first thing to execute in the program is a MessageBox.Show in the Connect
constructor.

Given the MessageBox and my previous experience with developing in VS2005
(with C++), my suspiscion is that there is some dll that should be deployed
that isn't done so automatically. Any thoughts on what the problem is? What
am I missing?

Please help...

Make sure the target machines have the redistributable .NET 2.0
framework on them.

 

[Carlos Valdivia]

Yup. That was already a prequisite. What wasn't (and what eventually fixed
the problem) were the following:

http://support.microsoft.com/kb/907417/

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

 

[Ken Wilson]

Yup. That was already a prequisite. What wasn't (and what eventually fixed
the problem) were the following:

http://support.microsoft.com/kb/907417/

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

I am glad I came back to this thread to see how you made out. I am
currently developing add-ins for both Word and Project. We have not
tried to produce a release version yet as we're still very much in a
development/beta_only phase so we may not have seen this issue. I've
set bookmarks for both pages should I need to return to them. It is
good to see you got your problem resolved, and possibly one of mine I
didn't even know I had yet. [