Excel Add-ins setup

[Aggie]

Hello

I have installed an Excel Add-in, and it works fine, but every time I close
Excel it dissapears and I have to install it every single time I open Excel.

does some one know what could be wrong?

 

[Gord Dibben]

Aggie

Generally you would place the add-in in your Office\Library folder.

Excel should find it there.


Gord Dibben MS Excel MVP

 

[Aggie]

Hello Gord

Thanks for your answer.
My add-in it's in a different location, coz it's part of a large product, if
I change the location, I think it won't help either.

I tried deleting the .xlb file but that hasn't solve the issue.

any more ideas?

 

[TGasecki]

Hello

I have installed an Excel Add-in, and it works fine, but every time I
close
Excel it dissapears and I have to install it every single time I open
Excel.

does some one know what could be wrong?

Did you try to add it in tools/addin menu?
you should have a tick near your addin name.

anyway you may try to put it to you addin:

Private Sub Workbook_Open()
AddIns.Add Filename:=ThisWorkbook.Path & "/YourAddinName.xla",
CopyFile:=False
AddIns("YourAddinName").Installed = True
End Sub

Tomasz