Excel Add-ins setup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Aggie

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

Excel should find it there.


Gord Dibben MS Excel MVP
 
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?
 
U¿ytkownik "Aggie said:
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?
Click to expand...

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
 
Back
Top