deployment - How to deploy an Excel XLL Add-In and automatically register the Add-In in Excel -

i have developed excel xll using exceldna , c#. @ point begin testing deployment, cannot find information provides steps work.

my project developed class library exceldna references. in .dna file, have code below pack resources packed version of xll (i.e. pack="true" attribute).

<dnalibrary name="excelxll" runtimeversion="v4.0" language="c#">   <externallibrary path="excelxll.dll" loadfrombytes="false" pack="true" /> 

i deploy packed xll target machine in path:

%appdata%\microsoft\addins 

in order automatically register xll excel, need add registry key depends on version of excel user has.

for instance, on computer (windows 7 64 bit running excel 2007 32-bit), need add registry key following path:

hkey_current_user\software\microsoft\office\12.0\excel\options\ 

the key type reg_sz name open (or open1, open2, etc.) , value /r "excelxll-packed.xll"

i have 2 problems though. first in determining version of excel user has correct path , 2nd determine correct open version need create (for example, if user has open, open1, , open2 create open3 key).

i trying installation using either setup , deployment project or installshield le project , cannot determine how go this. know how or better way of doing it?

edit 1:

i have done great deal of research on , have looked @ several windows installers.

in package , deployment , installshield le, can install/uninstall work putting installer class class library , bundling project output install. in approach, handle inserting/removing registry key using installer class. problem have user must uninstall first before running new install (no update capability).

i downloaded setup factory demo version , can install/update work cannot framework check (not shipped demo). also, uninstall fails (though may able work more investigation).

i interested in using wix installer, know if has sample of how perform deployment using wix. know if need use installer class or if there different way handle search open[n] key under hkcu\software\microsoft\office[version].0\excel\options. if use project output enable installer class, need have 2 separate target directories (one under program files basic project output , 1 under %appdata%\microsoft\addins packed xll).

any appreciated.

thanks,

lee

to detect excel 32-bit vs. 64-bit, can check registry: detect whether office 32bit or 64bit via registry

for open, open1, open2 etc. typically need custom action in install script enumerates keys.