+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: set data from excel file in vbs (/Thread-set-data-from-excel-file-in-vbs)
set data from excel file in vbs - devanggoel - 03-08-2010
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
RE: set data from excel file in vbs - manabh - 03-08-2010
Hi,
Simple way is to import that sheet in your test's datatable. Then you can access the file as a part of datatable.
RE: set data from excel file in vbs - Saket - 03-08-2010
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.