Extracting data from Website without web scraping

[Chefsohail]

Hi Team,

I need your expertise to extract data from a webpage.

So basically I have different Product ID's in column A. Now i want VBA to search a product ID in the search box of a URL and return values in the adjacent colums.

A	B	C	D
Product ID	Product Name	Serial	Use
123456789	Shampoo	23	Haircare
789101112	Conditioner	25	Haircarev

Now this is a recurring activity for different product ID's. I do not need to update the information as it does in web query in excel.
I also want to be careful not to get into any legal issues for web scraping.

So whats the best solution to get this done using vba. Please advice.

 

[Dan_W]

Webscraping is the act of extracting data from a website. More often than not (always?), it is the automated extraction of data. What you're describing above is webscraping. Whether or not there are any legal issues is, unfortunately, a legal question and - though I know you weren't asking for any - we cannot provide any form of legal advice.

But if all you're asking is whether it is doable in VBA, then the answer is (likely) yes. It will depend largely on how the website is coded (e.g., Javascript-rendered?).

Sorry I can't be of more help.