Deploying an Excel 2007 VSTO Addin

[Ross Culver]

I have several addin's that I have created using VS2k5 for Excel 2007 all of
which either create a new tab on the ribbon or add a group to the Addin Tab.
Of course they work fine on the development computer, but I cannot get the
addin's to deploy to any other computer.

I've created the Setup project and even added the HKLM registry entries
covered in Misha Shneerson's 2-part article (less the deletion part).

Now, after building the setup project and installing it on an XP machine
running Office 2K7 I am able to get the addin to appear in the Addin list
(Excel Options). It does not load at startup as set in the registry and as
appears in the Window when I select the COM addin to enable it. The addin
does appear in the COM addin list and I'm able to check the box and click OK
with no errors. But the addin never connects. I'm using a freeware product
called OfficeIns which shows the Addin as No for Connected. After selecting
the Addin to enable it (Excel Options) I close Excel and re-open but it is
not enabled/connected so the new tab(s) never show.

Below is just a snippet of the registry values.

Can anyone help me? Thanks.

Ross

HKLM
Software
Microsoft
Office
12.0
User Settings
OAAddin
Create
Software
Microsoft
Office
Excel
Addins
Warren.OAAddin
CommandLineSafe
1
Description
"Order Analysis Excel 2007 Addin"
FriendlyName
"Order Analysis"
LoadBehavior
3
Manifest
"[TARGETDIR]Order_Analysis.dll.manifest"