How to scrap the data from webpage by VBA script??
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.
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.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
VB Script
VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.
39K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
