New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
How to create list in excel using qtp

Thread Rating:
  • 1 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to create list in excel using qtp
venkatbatchu Offline
Member
***
Posts: 240
Threads: 38
Joined: Jun 2009
Reputation: 0
#3
Not Solved 04-12-2011, 10:12 AM (This post was last modified: 04-12-2011, 10:12 AM by venkatbatchu.)
Hi charan,

As per my understand,

I understood that you are looking for filter option in excel (List as per you terminology).

Code:
set objExcel=Createobject("Excel.Application")
set objWorkbook=objExcel.Workbooks.open("D:\venkat.xls")
set objworksheet=objExcel.worksheets("sheet1")
objworksheet.cells(1,1).autofilter
objworksheet.cells(1,1).autofilter 1,"99"   'It will filter the values w.r.t 99
objworksheet.cells(1,1).autofilter 2,"batchu"
objworksheet.cells(1,1).autofilter 1,"2"
set objExcel=Nothing
set objWorkbook=Nothing
set objworksheet=Nothing


Regards,
Venkat.Batchu
Find
Reply


Messages In This Thread
RE: How to create list in excel using qtp - by venkatbatchu - 04-12-2011, 10:12 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,696 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  Compare second web list value according to the first web list value roselin6 1 2,823 10-07-2015, 09:14 PM
Last Post: supputuri
  QTP: WebEdit : How to check if values in list are disabled. katdean 4 8,493 07-27-2011, 08:52 AM
Last Post: rajpes
  What is the difference between Description.Create() and Description.Create? njnirmal 1 6,392 07-31-2009, 05:24 PM
Last Post: Saket
  How to create testcases with VB script in QTP martin 1 3,055 12-02-2008, 10:07 PM
Last Post: roxer

Forum Jump:


Users browsing this thread: 2 Guest(s)