Shared Add-in for Excel 2003 using Visual Studio 2005 Pro

[kjell nilsson]

I try this question here also:

Hi! I have problems to get my new Addin up and running through Excel. For
some reason it doesn't seem to load to Excel 2003.
I am using the integrated Wizard,
I am doing like this:
New project -> other project types -> Extensibility -> Shared Addin, then i
am checking Visual Basic, Excel as host application and that it should load
on Application launch.
Then i try to run the addin, whilst i have a break point on Onconnet method.
But for some reason it doesn't stop there, and the addin isn't visible from
Excel.

I have tried to make an add-in for Visual Studio itself, via the Visual
Studio addin template, and that works fine.
Do anyone have any suggestions?

I have tried to install this update without any success:

FIX: 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
I have also lowered the security settings in Excel.
I have set a break point on Onconnect. But for some reason it doesn't break.
Under Excel->help it says that Excel has stoped the addin due to
incompability issues. But then i activated it anyway, and now it doesn't
appear there anymore. Any other suggestions please!?´

Best Regards Kjell Nilsson

 

[XL-Dennis]

Hej Kjell,

On it's face it looks easy to setup a shared add-in and it work as expected
however there are some issues 'under the hood' that make it more complicated.

Start to read my 9 (!) articles on the subject and pay special attention to
'blacklisted items' in the Troubleshooting article and also the article about
'shimming'. Here is the link to the collection:
http://www.excelkb.com/article.aspx?id=10204

Let us know how it progress.

-----------------
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/