How can spy/identify ActiveX control inside Ms Excel Wookbopk

[Anonymous]

I have one Excel workbook which having activex controls like combo box and I want to change combo box value dynamically . Using Windows or AA mode, we are not able spy these kind of element. Any one faced similar issue and what is the solution for same?

[KavitaJagadal]

Hi, Create a separate Excel object and from that open the required file(spy the open element). By this way you will be able to spy the MS Excel elements.