Launch n-times QTP Test with different Excel Files

[nacchio]

Hi,

I have to Excel files: File1.xls and File2.xls. I want to launch my QTP Test 2-times; the first time the test loads File1.xls, the second time loads File2.xls.
I want that this operation has automatized in a vbscript. The simplest solution, I think, is generate the script and the first put this code line

App.Test.Settings.Resources.DataTablePath = "C:\File1.xls"

and the second time this line

App.Test.Settings.Resources.DataTablePath = "C:\File2.xls"


Exist other solutions?


Thanks in advance

Andrea

[PrabhatN]

Hi Andrea,

You can make use of the environment variable "TestIteration". You can write the code below:

Code:

If Environment("TestIteration") = 1 Then
    DataTable.Import("C:\File1.xls")
    Else
    DataTable.Import("C:\File2.xls")
End If

Hope this helps!

[Nandana Vijay Kumar]

Hi Andrea,

Prabhat's solution is good. But if you find it difficult to create environment variables you can us a simplet for loop.
Please refer the below code:

Code:

For i = 1 to 2
  if i = 1 then
     DataTable.Import("C:\File1.xls")
  else
     DataTable.Import("C:\File2.xls")
  end if
Next

Thanks,
Nandana

[ravi.gajul]

"TestIteration" is a built -in environment variable ....so prabhat's code can be directly reused.
We need not create this environment variable.