Setting up Excel driver and using variables
Hi! I am running into some difficulties setting up my new scripts with variables contained in my Excel worksheet. I am converting my Keyword tests into Scripts and need to pass in my values contained ...
Forum Discussion
I have read those articles but they are mostly geared towards Keyword testing which I am no longer doing. I want to script my tests now. I have my Function set up that does all the heavy lifting, inserting the data, etc.. and which contains the variables and then I have my Test that calls the Function. I am calling my Excel driver within this Test and set up the one 'placeholder' variable that gets passed in with my project variables.
Example:
Sub TrueFalseTest()
Dim TrueFalse
TrueFalse = ""
Set Driver = DDT.ExcelDriver("C:\Users\server\TG_questionDataApril2014.xlsx", "TrueFalse", True)
While Not Driver.EOF()
Call Pub_TestGeneratorQuestions.Publisher_questionPanel1(questionTitle,questionStem,SelectAnswer)
Driver.Next
WEnd
End Sub
My variable for 'questionTitle' within the function looks like this:
Call title.SetText(Project.Variables.TrueFalse.Value("questionTitle"))
Should it just be:
Call title.SetText(("questionTitle"))
Thanks much!
Example:
Sub TrueFalseTest()
Dim TrueFalse
TrueFalse = ""
Set Driver = DDT.ExcelDriver("C:\Users\server\TG_questionDataApril2014.xlsx", "TrueFalse", True)
While Not Driver.EOF()
Call Pub_TestGeneratorQuestions.Publisher_questionPanel1(questionTitle,questionStem,SelectAnswer)
Driver.Next
WEnd
End Sub
My variable for 'questionTitle' within the function looks like this:
Call title.SetText(Project.Variables.TrueFalse.Value("questionTitle"))
Should it just be:
Call title.SetText(("questionTitle"))
Thanks much!
