The Datatable.Global has 2 rows and 2 columns. The 1st column is an action to perform. The 2nd column is data, in this case it is the name of an Excel file to open.
I can not figure out how to make the 2nd file open! It always opens the 1ft file - never moves to the 2nd file.
I hope the code below posted OK, it looks really odd in the post dialog...
msgbox "SetCurrentRow is: " &SetCurrentRow
Select Case DataTable("Action")
Case "Open Excel File"
msgbox "Adding sheet ->testSheet : " &DataTable("Input")
strTestPath="C:\Program Files\Mercury Interactive\QuickTest Professional\Tests\"
txtScriptPath = strTestPath & DataTable("Input")
msgbox "Importing script using txtScriptPath: "& txtScriptPath
DataTable.ImportSheet txtScriptPath ,1 ,"testSheet"
msgbox "Imported sheet name: " & txtScriptPath
msgbox "Opening script: "& txtScriptPath
Social Engineering - do they ever use QA?
I fixed it...it seems right at the start of the 2nd iteration when I added:
it picked up the value in the 2n row of the Global sheet.
Ack not really the 2nd iteration, but EACH iteration. Still works, well at least for now.