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 search a value in excel sheet using vb script

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to search a value in excel sheet using vb script
basanth27 Offline
Moderator
*****
Posts: 1,003
Threads: 1
Joined: Jul 2009
Reputation: 5
#4
Solved: 11 Years, 4 Months, 3 Weeks ago 10-07-2009, 07:16 PM
It is normal for it behave so. Your exploitation of the COM is one which is actually taking time. The init , execute action requires several seconds.
What is the total time taken for the execution ? Morever you havent killed the Excel object.You should do that else excel.exe wouldnt let you open another copy.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Find
Reply


Messages In This Thread
RE: How to search a value in excel sheet using vb script - by basanth27 - 10-07-2009, 07:16 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  how to select value from google search box dropdown +QTP prajyot 0 2,925 06-28-2017, 06:30 PM
Last Post: prajyot
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,738 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  Search and import data from excel under some rules. nwpulele 2 2,978 02-19-2015, 04:10 AM
Last Post: supputuri
  Excel and Driver Script shipu 1 3,866 02-27-2014, 09:09 AM
Last Post: supputuri
  Custom sort -Excel Sheet kiran 1 3,901 01-28-2014, 09:23 AM
Last Post: supputuri

Forum Jump:


Users browsing this thread: 4 Guest(s)