+- 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,47Thanks.
-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.