Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
QTP and Excel - Performance
#3
Not Solved
Hi Saket,

Thanks for trying. I'll give you a sample of the excel processed file and a copy of the main QTP script.
The Excel file usually contains about 40.000 lines. The script is launch by a .vbs programm. In fact, it is launched about a hundred times because I had to stop and restart QTP frequently to avoid memory problems. Each time it runs, the script opens the excel file, restarts at the line where it stopped and processes the next lines before saving the excel file and stopping again.

If you have any question about the script, please ask.

I'm using Windows XP Professional 2002 SP2 + IE6


Attached Files
.doc   Problem.doc (Size: 41 KB / Downloads: 93)
.zip   sample.zip (Size: 517.43 KB / Downloads: 116)
.zip   Script.zip (Size: 6.74 KB / Downloads: 71)
Reply


Messages In This Thread
QTP and Excel - Performance - by Vandembergue - 11-29-2010, 09:30 PM
RE: QTP and Excel - Performance - by Saket - 11-30-2010, 10:42 AM
RE: QTP and Excel - Performance - by Vandembergue - 11-30-2010, 07:28 PM
RE: QTP and Excel - Performance - by Saket - 12-01-2010, 12:54 PM
RE: QTP and Excel - Performance - by Vandembergue - 12-01-2010, 03:15 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Performance Issues Using '.Exist' AndyBSG 2 3,280 12-12-2014, 03:24 PM
Last Post: AndyBSG
  QTP Performance is very slow rajaselvan.d 0 2,704 04-10-2012, 04:25 PM
Last Post: rajaselvan.d
Question Writing performance tests using QTP 9.2? pointguard888 1 2,967 02-23-2011, 08:00 PM
Last Post: basanth27
  QTP9.2 concurrent version performance TaraNavin 3 2,811 07-14-2010, 12:55 PM
Last Post: TaraNavin
  excel macro to open QTP from excel karthik1979_us 1 10,951 11-07-2009, 02:57 AM
Last Post: geethwind

Forum Jump:


Users browsing this thread: 2 Guest(s)