Deploying an Excel 2003 Automation addin (C#)

[Isaac]

I'm having some trouble in deploying the C# Automation addin on a user
machine.

To briefly tell you the situation, I had developed a C# Automation addin
using VS 2005 and it's working fine on my machine with Office 2003 . I wanted
to give this to another user for testing.So created an MSI with primary
output's Register property to "vsdrpCOMRelativePath".

Got it installed on the new machine ( with .net 2.0 framework and Office
2003).And started Excel and i can see the Addin in the List of addins (Tools
--> Addins), But when i try to enter the function in a cell it's not
recognised and on checking in the "Insert Function Dialog box" , my addin is
not appearing in the list.

I ran Regasm to ensure that the "Programmable" key is present for the dll.
And i can see that the dll is registered correctly

Secondly tried to GAC it. But without much luck... on googling a bit and
searching the msdn forums found an article
http://support.microsoft.com/default.aspx/kb/908002 .

I even tried the steps mentioned in this article. But still it's not working.

Any help to solve this issue is greatly appreciated. Please let me know if
you need any further info.

Thanks in advance for your help
Isaac Varghese

 

[Otavio]

Hi! Isaac... It's been a long time that I have the same problems as you. I
corrected some, but not all of them. I can list the problems, if you want:

- problem: object com not recognised; solution: change the property
comvisible of file assembly. the propety must be "true".

- You must install O2003PIA.exe and vstor.exe for run the automation add-in
create by VSTO.

- You must have the .NET Framework 2.0 installed

- If your add-in is visible in Excel, but not his functions, you must change
the declarations of functions. The functions declared as Static doesn't
appear in Excel.

It works fine in my computer, but unfortunantely my automation add-in
doesn't work in another computer ... If you trouve une solution, write me
please.

thank you!