VSTO Excel add-in only working in development machine

[Abhishek99]

Hi,
I am creating a Excel 2007 VSTO COM Add-In using VSTO 2005 SE . It runs
perfectly fine when I build it and run the in development computer having VS
2005.

However, when I try to install the setup.exe or .msi file for the same addin
in the client machine or Virtual PC having the following installed:

1. VSTO Runtime - Shipped with VSTO 2005SE
2. Office 2007
3. .NET 2.0 Framework

it does not seems to load .

I have done :

1. caspol settings to make it Fully Trusted .
2. set vsto_suppressdisplayalert=0 and run excel.exe from cmd ......Same
Results ....

I get the following error " Not Loaded. A runtime error occurred during the
loading of the COM Add-in."

It has been over a week now that I am struggiling with the same problem .
Its not only me but the entire development team is struggling with the same
problem.

 

[XL-Dennis]

Hi,

It's difficult to give more detailed answer, especially when You seems to
have already made all the necessary actions. However, please keep in mind
that both Excel 2007 and the VSTO 2005 SE are in the beta stage.

Anyway, see if the following KB-article from MSFT may help:
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

Some general troubleshooting:
http://www.excelkb.com/article.aspx?id=10206&cNode=7T5V0N

Migrating a Shared Add-in to a Visual Studio Tools for Office Add-In
http://msdn2.microsoft.com/en-us/library/aa663367.aspx

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/