perpetual_dream

Everything used to work just fine. Now my excel addin doesn't load in excel, and the addin doesn't catch the addin start event....! everything is fine with word/outlook/powerpoint. My sole problem is EXCEL!

Nothing special

Code Snippet

public class ThisAddIn

Private Sub ThisAddIn_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup

' Start of VSTO generated code

Me.Application = CType(Microsoft.Office.Tools.Excel.ExcelLocale1033Proxy.Wrap(GetType(Excel.Application), Me.Application), Excel.Application)

MsgBox("hi2")

' End of VSTO generated code

End Sub

Private Sub ThisAddIn_Shutdown(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Shutdown

End Sub

!!!


Re: Visual Studio Tools for Office excel addins doesn't load

jackpotek

"I believe you must ensure that the vs2005-kb908002-enu-x86.exe update is deployed with the project. I personally use VS2003 so may be wrong about this but I believe:


After you install this update, whenever you create a shared add-in project in Visual Studio 2005, you must include the Shared Add-in Support Update for the Microsoft .NET Framework 2.0 (KB908002) option among the prerequisites in the solution Setup project. To do this, follow these steps: 1. In Solution Explorer, right-click the solution Setup project, and then click Properties.
2. Click Prerequisites.
3. Click to select the Shared Add-in Support Update for the Microsoft .NET Framework 2.0 (KB908002) check box.
Note You must enable this prerequisite separately for both Debug and Release builds."


details under : http://www.add-in-express.com/forum/read.php FID=5&TID=1306

Worked for me

Cheers!




Re: Visual Studio Tools for Office excel addins doesn't load

Ji Zhou ¨C MSFT

Hi,

Could you please tell more information about your issue

1. Is this happened in debug model or after your installing it to target machine

2. Does the add-in appear in Excel¡¯s Com Add-in Dialog with an unchecked status

3. When did this problem come up Has your add-in worked properly before

4. If you create a new Excel project. Does the same issue persist

With more valuable information, people here may give useful clues if similar experience they have met.

Thanks

Ji






Re: Visual Studio Tools for Office excel addins doesn't load

Gastiflex

Hi,
Did your addin stop working after a crash If yes, Excel as desactivated it and you must re-activate it manually.
Click on the Office button, go into the "Add-in" section and check if your add-in appears in the desactivated add-in list. Then, click on the combo box and select "Desactivated elements". You should be able to re-activate your add-in.