Unable to get the Add propert of the addin class

J

jayklmno

I am trying to uninstall an old addin and install teh new version by having
the user open a workbook. The code I am using is as follows:

Sub Install_Grid_addin()

Dim oAddin As Object

If AddIns("Grid_Addin").Installed = True Then
AddIns("Grid_Addin").Installed = False
End If

Set oAddin = AddIns.Add("\\networkpathtofile\Grid_addin.xla", True)
oAddin.Installed = True

MsgBox "Installed!", vbExclamation

End Sub

It continuously generates a "Unable to get the Add property of the addins
class."

What might be the error or is there a better way?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top