I have the URL of a webpage, in which i need to scrap the data from.
The URL will be send to my email. In outlook, I have created the rule with VBA script to fetch the URL from the mail when it received. Now I need to scrap the data from the URL page using VBA script. I tried to get the code from internet. They all scripted to get values from the web page table into excel, but i need it to store as text in VB variable.