Hello,

I am trying to find a way to get qtp to login to a system we use using data from a text document/spreadsheet, so rather than re writing the script each time we change user we can just edit the data in the spreadsheet/text document.

Here is an example of the script to logon:
VbWindow("MDIMain_[0-9]+").VbWindow("frmLogin").VbEdit("txtUsername").Set "jamesb"
VbWindow("MDIMain_[0-9]+").VbWindow("frmLogin").VbEdit("txtPassword").SetSecure "488846086df549d68135bc3996d61c1029552651e01f"
VbWindow("MDIMain_[0-9]+").VbWindow("frmLogin").VbButton("Login").Click
VbWindow("MDIMain_[0-9]+").VbWindow("frmLogin").VbButton("OK").Click 35, 15, micMiddleBtn
VbWindow("MDIMain_[0-9]+").VbWindow("frmLogin").VbButton("OK").Click
VbWindow("MDIMain_[0-9]+").Dialog("Activity List").WinButton("No").Click

any help on this matter would be greatly appreciated.

regards James.

DataTable is an inbuilt spreadsheet for QTP script, u can place the strings in datatable & fetch them in the script.


DataTable(dtlocalSheet,"UserName")
DataTable(dtlocalSheet,"Password")

UserName & Password are the Columns in the DataTable...

Also please check the manual and revert in case there are any implementation issues.

regards,
Nawab