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?
venkatbatchu Offline
Member
***
Posts: 240
Threads: 38
Joined: Jun 2009
Reputation: 0
#3
Solved: 11 Years, 4 Months, 3 Weeks ago 10-08-2009, 12:47 PM
Thanks saket for replying,
i have tried with that and got the message like this
"---------------------------
Windows Script Host
---------------------------
Script: C:\Documents and Settings\venkat.batchu\Desktop\To get a value from specific row and 1coloumn from excell.vbs
Line: 5
Char: 1
Error: AutoFilter method of Range class failed
Code: 800A03EC
Source: Microsoft Office Excel

---------------------------
OK
---------------------------
"
Venkat..
Find
Reply


Messages In This Thread
RE: How to perform the Filter action in excel using vb script? - by venkatbatchu - 10-08-2009, 12:47 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: 3 Guest(s)