executing a com addin function with a macro?

I have a com addin I use for running analysis on systems. It is not listed in the AddIn block, but is loaded in the comAddIns. Is there a way I can execute the AddIn's functions via VBA? Using Excel 2010

Thanks in advance for your time!!

Solution 1:

Yes it's possible to execute Add-Ins through VBA. But I would like to suggest you few simple steps, help you to recover your COM Add-Ins.

• Load Excel if not.
• Click the File command, hit Options.
• Find Add-Ins from the Menu.
• Check left bottom for Manage, then select Disabled Items and then Click Go.
• From pop-up windows find your add-ins, select it and click Enable.

or

• Click Manage button, and from the list select the COM Add-Ins then OK.
• From COM Add-Ins Pop up windows find your Add-Ins, select it and Finish with OK.
• Finally Restart Excel.

EDITED PART:

Inducded this part on OP's demand, since OP need to run Third Party Add-In, as mentioned in comments below, from VBA code.

Private Declare Function XLLFunction Lib "C:\PathTo3rdPartyDLL\3rdParty.xll" (ByVal A as Integer, ByVal B as String, C as Double) As Double

Sub Function ThirdPartADDInRUN(A as Integer, B as String, C as Double) as Double
    ThirdPartADDInRUN = XLLFunction(A, B, C)
End Sub

NB: Specify the File Path & ADD-In name exactly as on your system drive.