Get data from web to my worksheet with the help of a code.

Hello code experts.
I am trying to get the data from the web from a particular web site into my excel sheet. I can do this manually. If it is possible to write a code and get the same result it would just be cool. Can anyone tell me whether it is possible.?
I have to copy the ID number from my workbook and paste it on the site in a particular box and it will display the result. Then there is an option in the page to download the data in an xls format.
I want to insert a button in the sheet so that when I press the button to run the code, it should open that particular site, copy the ID's from the workbook and paste it in that particular box, run the button on the web to get the result and get the data in xls in my workbook.

Yes it is possible.
A lot depends on the webpage itself (is it just html, javascript, ...)
To start you can watch: https://www.youtube.com/watch?v=T6HRjiAdW38

All webpages are constructed differently. Can you provide actual webpage? Most people use Selenium to get web data. There is an addin for Excel called SeleniumBasic. The problem with using Microsoft Internet Controls is MS is discontinuing IE and many webservers won't work with it. Many of Microsoft's webservers don't work on IE.

I have already shared this query on another forum. I hope it is not an issue if I share the link here.

I have already shared this query on another forum. I hope it is not an issue if I share the link here.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

Please post the link now so that others here do not waste time. If you understand the rules, then follow them now. It is common courtesy.