Get data from online with code

[RAJESH1960]

Hello code experts,

What I am trying to do today is something what I have not tried and not ever heard before..

I am trying to get data into my workbook from an online site with the help of a code. I am sharing this video and the workbook in the links below. The video shows what I am trying to do exactly and the workbook contains the steps involved to do the same. I have also the expected result sheet in the workbook.
Loading Google Sheets

Video - Get Data from online site.mp4
The site to get the data from is Check GSTIN/UIN Number Format | GSTZen

EDITS:
3 Links I shared. One is the video, the other is the workbook and the 3rd one is from where I need the data

The 3rd one is a free site. Anyone can get the details of any GSTIN number provided it is correct. If it is wrong it will display a x on the right side else a tick mark stating it is correct.

 

[RAJESH1960]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Get data from web to my worksheet with the help of a code. [SOLVED]
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

https://www.excelforum.com/excel-programming-vba-macros/1379639-get-data-from-web-to-my-worksheet-with-the-help-of-a-code.html