VB Run Time Error '1004': Unable to get the Add property of the Addins class

Viewed 369

I inherited an excel file that installs an addin off of a network folder for analysts at my company. This file works for nearly everyone who uses it. Recently, two analysts have been getting the error "Run Time Error '1004': Unable to get the Add property of the Addins class"

Code:

Sub InstallAddIn()
    
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    
    Dim AI As Excel.AddIn
    Set AI = Application.AddIns.Add(Filename:="\\apps\www\net\wwwroot\b-ratings\research\tools\addin\RMTools.xlam")
    AI.Installed = True 
End Sub

Please let me know if there are any additional details needed

0 Answers
Related