View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
seisman seisman is offline
external usenet poster
 
Posts: 15
Default Installing an Add-in from outside Excel

Thanks Robin,
In a similary way to your technique I use Tarma Installer to create
installation packages and that uses a Shell call to run any program or
document you specify at the end of the installation. I use that to run
an "Activate.xls" workbook with code in the AutoOpen subroutine to
install and activate the addin in Excel. I was hoping to streamline
this a bit by accessing the registry directly (something that the Tarma
Installer allows you to do). Okaizawa's post provides the clue to
dointg this however it is not as straight forward as I had hoped as you
have to count thenumber of OPEN keys in the
HKEY_CURRENT_USER\Software\Mic*rosoft\Office\10.0\ Excel\Option*s
folder and add the next one in the sequence. Tarma allows you to link
a dll to the installation routines it produces so I'd probably be able
to do it that way. (I Downloaded XspandXL by the way - it looks
interesting).
Seisman.