descriptive programming in excel

[shipu]

Hello,

I want to write a descriptive programming to select a specific value from a drop down field in the excel. I am not able to recognize the drop down field using object spy. When I click the drop down field during recording, I see the below code. How can i write descriptive programming to select a value?

Code:

Window("Book1").WinObject("NetUIHWND").Click 180,62  ''region

Window("Book1").Window("Window").WinObject("NetUIHWND").Click 28,47

Thanks.

-S

[guin.anirban]

Boss,

Is this the right approach?
Plz try the same with CreateObject method for excel application if you want to stick with QTP. Otherwise my suggestion if you want to handle excel like as you told selecting value from dropdown then go for Excel Macro.