descriptive programming in excel

descriptive programming in excel - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: descriptive programming in excel (/Thread-descriptive-programming-in-excel)

descriptive programming in excel - shipu - 02-04-2014

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

RE: descriptive programming in excel - guin.anirban - 02-25-2014

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.