I am looking to get a web form filled with excel data wherein VBA opens the URL from the list and then fill the data as per the excel cells data (B2, C2, D2...)
Refereed some online data and tried to get the code of the web page which might help you in getting a solution
Steps to follow:
Open web page using URL
enter/fill data as per excel
submit the page
Next URL and loop
Web page has drop down as well as text box
It will be of great help as it becomes a long job to fill a list of 1000+ data. Rest I may follow through and this is to start with (Ignore me as I am just getting close to programming as starter only)
Refereed some online data and tried to get the code of the web page which might help you in getting a solution
HTML:
Test Widget Test Company Choosexxx 1234xxx 4569xxx 8745 Test Client ChooseBBB 1456DDD 45236WWW 12589 ******** type="text/javascript">...... *********>
Steps to follow:
Open web page using URL
enter/fill data as per excel
submit the page
Next URL and loop
Web page has drop down as well as text box
It will be of great help as it becomes a long job to fill a list of 1000+ data. Rest I may follow through and this is to start with (Ignore me as I am just getting close to programming as starter only)