I am looking to auto fill data from excel on to a web site and submit. This consist of a looping through the WEB address in excel sheet and filling the data in form as per the values provided in excel.
Steps which I follow with each URL are as (which might help you to understand)
Cell A2 - copy the link and open in Internet explorer (Web page data fields are same with all URL, just the address is different)
Cell B2 - copy the data and paste in web page (drop down)
Cell C2 - copy the data and paste in web page (Text Box)
.
.
.
.
Cell H2 - copy the data and paste in web page (Text Box)
Now in web page there are some Text box, Drop down box as well
Let me as how we can move next and what info is required for your help (like Get element or drop down options)
(I am not sure about it so requesting to let me know as what is required to resolve this)
Steps which I follow with each URL are as (which might help you to understand)
Cell A2 - copy the link and open in Internet explorer (Web page data fields are same with all URL, just the address is different)
Cell B2 - copy the data and paste in web page (drop down)
Cell C2 - copy the data and paste in web page (Text Box)
.
.
.
.
Cell H2 - copy the data and paste in web page (Text Box)
Now in web page there are some Text box, Drop down box as well
Let me as how we can move next and what info is required for your help (like Get element or drop down options)
(I am not sure about it so requesting to let me know as what is required to resolve this)
