QTP and Excel - Performance

[Vandembergue]

Hi Folks,

I have built an automatical test with QTP that retrieves values in a excel file (on one line), checks those values in a web application and reports the results (OK/KO) into the processed excel line. The excel file is processed line by line.

I can see how fast the programm is running by observing how fast the excel line are fulfilled from top to bottom.

The strange thing is that i've observed that when as I was clicking the horizontal scroll bar of the excel window and maintaining the click on it (not releasing the left button), QTP would update the Excel file twice as fast (at least).

Am I clear ?

Is there anybody who could explain me why clicking on the scroll bar makes QTP perform better ? Do you have any idea of how I could improve my program so that it runs as fast as if I was clicking the Excel window ? If turn my excel application to Set ...Visible=No, would it change something ?

Notes :

- in QTP script my excel file is opened that way :
-----------------------------------------------

Code:

Nom_Xls = "C:\...\TESTS QTP\INPUT\Extract_OpenCat_Offres.xls"
Set ObjExcel = CreateObject("Excel.Application")
Set Classeur = ObjExcel.WorkBooks.open (Nom_Xls)
Set Onglet = Classeur.Worksheets("Extraction")
ObjExcel.Visible = TRUE

- The QTP script is launched by a vbs file :
-----------------------------------------

Code:

qtApp.Launch
qtApp.Visible = True
qtApp.Options.Run.RunMode = "Fast"
qtApp.Options.Run.ViewResults = True
qtApp.Open Test_path, True
Set qtTest = qtApp.Tt
qtTest.Run ' Run the test