How to explore an Excel COM AddIns and automate it

Question

I have a COM Add In, in excel from RIMES. It basically allows me to get data, there is a specific button refresh all data. I am loading the data in R and do calculus. I would like to avoid having to open and refresh the excel file before loading the data. In other words I would like something to "click on refresh all". I figured I could do a VBA script that would do that, however I cannot figure what are the functions embedded in the excel add-in. How can one "explore" the com addin ?

Thanks

you can try a decompiler such as http://www.telerik.com/products/decompiler.aspx — Sorceri, Sep 29 '14 at 17:19
That's a good idea. Any clue what kind of key words I should be looking for ? — Romain, Sep 29 '14 at 18:41

score 0 · Accepted Answer · edited May 23 '17 at 11:49

0

I was finally able to find a proper solution, turns out there are templates that are created form the COM ADD IN that uses the function refresh which is then available in VBA. One can then use a VB.script to create a way to compute everything without opening excel.

How To Create a VB.Script (StackOverflow)

Cheers R

edited May 23 '17 at 11:49

Community

1
1

answered Oct 01 '14 at 18:12

Romain

839
10
24

How to explore an Excel COM AddIns and automate it

1 Answers1