VB Controls with Macros embedded in Excel Document
 

Hi,

I actually would like to automate an Excel tool which is embedded with VB
Controls such as Listbox, PushButton, Checkbox etc which inturn is linked
with macros. I'm trying to automate this tool with the help of a automation
tool such as quick test pro which actually does not provide support to do.

Can you guys help me find an solution where i can interact with these
controls in an alternate way.

1. Is there any way of getting the parameters required for the macros through
code?
2. Is there any way of creating additional macros which can interact with
the VB controls placed in the excel tool?

Any help would be appreciated. Thanks beforehand!