Search code examples
excelcommand-linewindows-7add-in

How can I activate an Excel add-in from the command line in Windows 7?


Currently I'm writting VB functions and save them as an Excel addin .xlam file.

I want to have a .bat script so as to quickly deploy those addins.

Currently, to activate my .xlam addins, I have to Open Excel - File - Option - Addins - Browse to addin files... as below screenshot. This is absolutely manual, repeated & tiring thing to do.

So my need is to automate the activation process.

enter image description here


Solution

  • After one manually added time, we can update the addin by copy the addin file to Excel addin lair. Here is the .bat script to do it.

    set       fipAddin=".\FIPphase2.xlam"
    set excelAddinLair="%APPDATA%\Microsoft\AddIns"
    
    copy %fipAddin% %excelAddinLair%
    

    Hope it helps!