Chefsohail
Board Regular
- Joined
- Oct 3, 2020
- Messages
- 90
- Office Version
- 365
- Platform
- Windows
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.
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.
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.