'Mapping Addin Buttons to library function
This is a followup question to my previous question : Controling Excel Instance on a Remote Virtual Machine with VBA
Basically, now I have an Excel in front of me that has an AddIn that is enabled. In the ribbon I have various buttons that I click in order to connect to a DB and download data. See picture below:
I want to be able to use the functions of this AddIn to recreate my button clicks. I went to tool references and I noticed there were a lot of tll and tlb files for this Data Genic AddIn, see picture below, so I ticked them all:
With the help of this question : how to find functions in a vba reference library, I could find all the functions in each of the .tlb files that I ticked
However, there are so many functions ! Is there a way to find out which function is called when I click on the connect button for example ? I tried record macros, but it didn't worked so I am now stuck again.
Please help.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|