Micro Focus QTP (UFT) Forums

Full Version: descriptive programming in excel
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
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.