set data from excel file in vbs

[devanggoel]

hi all
can any friend help me to write the VBS code in qtp to get the the data from excel file from my computer or other and insert into the text fields on forms. suppose i have a form with 3 fields like username, email,and phone. this information is saved in excel file according to the field's name in column.


thanks

[manabh]

Hi,
Simple way is to import that sheet in your test's datatable. Then you can access the file as a part of datatable.

[Saket]

hi devang,

have you tried searching this forum, there are many threads on the same topic discussed earlier.
you will definitely get help from there and can try yourself.

let me know if that does not help you.