load - Using Registry to install Excel AddIn -

i created excel add-in called

project count_per person.xlam

when open excel , go development>addins , select addin install, not stay installed if close out of excel after saving. addin made, creates new menubarbutton under tab 'addins'

so created new registry key install addin @ startup under

hkey_current_user\software\microsoft\office\excel\addins\projectcount_perperson

the key looks this

(default)     reg_sz        (value not set) description   reg_sz        project count_per person friendlyname  reg_sz        project count_per person loadbehavior  dword         0x00000003 (3) manifest      reg_sz        c:\users\b012918\appdata\roaming\microsoft\addins\project count_per person.xlam 

when start excel, displays installing addin, an

exception reading manifest from

file:///c:/users/b012918/appdata/roaming/microsoft/addins/project%count_per%person.xlam:

the manifest may not valid or file not opened.

http://pastebin.com/bn1datv5

any insight i'm messing beneficial.

additional information:

if addin uninstalled when start excel, gives manifest error. if addin 'checked' when start excel, gives download error in comment below. if addin installed, commandbarbutton not stay in place. also, under options--> addins addin stated "active".

just clarify, there 2 types of addins excel (and other office apps), vba addins , com addins. com addin developed via visual studio , visual studio tools office. brett s referencing to.

but more type normal vba excel addins, typically distributed via .xlam file. in order load such addin automatically user, need addin file on local directory on machine , reference via registry. excel 2010, reg file load corresponding registry key is:

windows registry editor version 5.00 [hkey_current_user\software\microsoft\office\14.0\excel\options] "open"="c:\\path\\to\addin\\addin.xlam" 

this way addin loaded everytime start excel.