how to incorporate an excel add in into a sub

I purchased an excel add in some time ago called analyzer excel. It basically loads historical stock price data at a press of a button that I then analyze.

What I'd like to do is incorporate the loading of the price data sub into one of the subs I'm writing. I've contacted the developer of the software in an attempt to get the name of the sub that I can call and run within my sub, but have gotten no response.

Also tried just recording a macro, press the price load data button on the add in, but nothing shows up in the code.

Is there any other way to do this?

Thank you.

Never used it myself but it looks like they want you to buy something else before you can control it with VBA: http://analyzerxl.helpserve.com/inde...wnloaditemid=2

Dom

If you want to just simulate clicking the button, you need to work out the commandbarcontrol and then you can use its Execute method.

OK, finally figured it out. You have to create a refference to one of their modules which does show up. Thank you anyways.