View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SilkAscent SilkAscent is offline
external usenet poster
 
Posts: 1
Default 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!