COM ADD-IN FOR EXCEL 2002 .NET C#

See more:

COM

Hello everyone, I am trying to develop a COM Add In object to run under excel 2002. I am having some problems. Thanks in advance for any help to point me in the right direction.

I am using Visual Studio 2005 Professional Edition.

To create the code I used the Visual Studio Shared Add-in Project Template and these options. Wizard Page:
1 of 5: Create an Add-in using Visual C#
2 to 5: Check Word, PowerPoint, Outlook, Excel, and Access ONLY
3 of 5: Use Default Values
4 of 5: Check the the Top box only
5 of 5: Finish

I Added project reference to System.Windows.Forms.DLL

Next I default constructor of the generated code to display a message when the COM Add-in is loaded by the Host Application:

public Connect()
{
 try
 {
    System.Windows.Forms.MessageBox.Show( "THIS IS THE ADD IN -- CONSTRUCTOR" );
 }
 catch ( Exception ex )
 {
    System.Windows.Forms.MessageBox.Show( ex.ToString(),"Somthing Went Wrong" );
 }
}

The automated code also created a deployment setup project.

I build both projects and installed the setup project.

I check the registry to verify that keys are set correctly.

This is what I found:

HKCU\Software\Microsoft\Offic\Excel\MyComAddIn.Connect\LoadBehavior = 3

all the keys for the other offic componets were set the same as the one above.

MY OFFICE COMPONENTS ARE:
Access 2002
Excel 2002
PowerPoint 2002
Word 2002
Outlook 2003

When I ran each of the above office components this is what happened:
Access = Worked Fine
Excel = add-in did not execute; changed LoadBehavior key to 2
PowerPoint = Worked Fine
Word = add-in did not execute; changed LoadBehavior key to 2
Outlook = worked fine


I have been digging into this problem for a while and I am getting now where.

The latest Idea that I have come up with is that I think EXCEL is trying to load OLEAUT32.DLL from the \Framework\v1.1.4???? directory, but this DLL is not in the v1.1.4 framework directories.

Does anyone have any ideas ?????