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 perform the Filter action in excel using vb script?

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to perform the Filter action in excel using vb script?
Saket Offline
Super Senior Member
*****
Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation: 0
#4
Solved: 11 Years, 4 Months, 3 Weeks ago 10-08-2009, 12:59 PM
how many autofilter you have on the sheet?
use in the syntax below
c.cells(1,5).autofilter <<autofilter fileld Number>>,<<your selection criteria>>
if you have only one autofilter field in the sheet then
use c.cells(1,5).autofilter 1,"Selection criteria"

does this work now?

Find
Reply


Messages In This Thread
RE: How to perform the Filter action in excel using vb script? - by Saket - 10-08-2009, 12:59 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Excel and Driver Script shipu 1 3,866 02-27-2014, 09:09 AM
Last Post: supputuri
  Filter multiple columns in excel kamalteja 0 3,833 07-08-2013, 02:28 AM
Last Post: kamalteja
  Ways to perform extraction AAB 4 4,213 06-05-2012, 09:05 PM
Last Post: supputuri
  Difference between parameter tabs in Action Properties and Action Call Properties. vibhakhandelwal 0 4,117 11-16-2011, 01:34 PM
Last Post: vibhakhandelwal
  Update a value in excel sheet during runtime & use the value later in the same script SweetyChowdhury 3 5,447 09-08-2011, 03:33 PM
Last Post: souvikghosh_diatm

Forum Jump:


Users browsing this thread: 5 Guest(s)