Hi Venkat,
Try using the arguments for autofilter.
see if this works for you
Try using the arguments for autofilter.
see if this works for you
Code:
c.cells(1,5).autofilter 5,"a"
Micro Focus QTP (UFT) Forums
›
Micro Focus UFT (earlier known as QTP)
›
VB Scripting/Descriptive Programming
How to perform the Filter action in excel using vb script?
How to perform the Filter action in excel using vb script?
|
How to perform the Filter action in excel using vb script?
|
|
« Next Oldest | Next Newest »
|
| Messages In This Thread |
|
How to perform the Filter action in excel using vb script? - by venkatbatchu - 10-08-2009, 10:53 AM
RE: How to perform the Filter action in excel using vb script? - by Saket - 10-08-2009, 12:36 PM
RE: How to perform the Filter action in excel using vb script? - by venkatbatchu - 10-08-2009, 12:47 PM
RE: How to perform the Filter action in excel using vb script? - by Saket - 10-08-2009, 12:59 PM
RE: How to perform the Filter action in excel using vb script? - by venkatbatchu - 10-08-2009, 02:09 PM
RE: How to perform the Filter action in excel using vb script? - by Saket - 10-08-2009, 02:51 PM
RE: How to perform the Filter action in excel using vb script? - by venkatbatchu - 10-08-2009, 03:05 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 |
|
Users browsing this thread: 6 Guest(s)