Basically trying to interact with a third-party OfficeApp (defined via an XML manifest) in Excel using VBA. More specifically it is an a TaskPaneApp with a clickable icon to launch.
I have tried for a while now but couldn't figure it out. Accessing Application.CommandBars, Application.AddIns, Application.AddIns2 and Application.COMADDIns doesn't seem to work. Googling doesn't give any hints either. Does anyone know if this is possible?
A macro cannot access a private variable declared in an add-in. That puts you in a pretty difficult position.
One option would be to contact the author of the add-in and ask them to do one of the following:
Another option could be to decompile - but you should check the license of this add-in to see if it's legal. Then add the functionality that you need. However check the license first and terms/conditions. There are situations for older plugins where the author could have lost the original source code or where they give you permission because they don't care anymore.
Have a look at the following: Possible to view source code or decompile XLL Excel add in
Also have a look at the following which details an example of how to call an excel-add-in function from vba: Call Excel Add-In function in macro and specifically https://stackoverflow.com/a/35518426/1688441
Early Binding / Late Binding
Within the VB editor it is possible to reference the Object Library for the Office applications. This reference to the object library is saved within the Excel file itself. Therefore, any time the file is opened the reference to the Object Library is still intact and is already available.
In the Visual Basic Editor select Tools -> References.
read here for more details its what you are looking for I assume .
https://exceloffthegrid.com/using-vba-to-control-other-office-applications/
