Web Scraping Using Excel VBA

Web Scraping Using Excel VBA

• Webscraping means how to get the information from any website without doing any manual handling.

• You will be able to download the data from a website or click on buttons or get the paragraphs content, tables contents and so much.

• This course will teach you how to do the Web Automation via Internet Explorer - No more manual stuff. It can be done using automation now. Please note it is going to be done only by internet explorer

• Learn every thing about loops use and if conditions in  Web Scraping using VBA in internet explorer

• This course is Basic to Advance Level Course so you can definitely join it but it does not discusses vba basics.

• How to work with A tags

• How to work with Class Tags and what are the class tags. What type of issues one can face while dealing with classes is also something we have discussed.

• How to work with input tags,ID tags

• What is a class in HTML and how and why we create them in HTML

• What is  a document , its class and document elements - object hierarchy discussion

• How we can click on links in website

• How to put the information in website forms

• How to download the excel or csv files from internet

• Assignments for you to practice

• How to debug the program if you are not able to click on link despite it is available on web page

• Use of immediate window to see more properties of tags like A tag,ID,Class,input, headers etc.

• Export tables details in excel from a web page

• How to work with already opened web-pages

Web Automation made easy with VBA

Url: View Details

What you will learn

• How to scrape website using Internet explorer browser.
• Complete tutorial from basics to advance - Using VBA
• You will learn everything - from clicking on website links to putting the information in web forms.

Rating: 4.6

Level: Expert Level

Duration: 8 hours

Instructor: ajay parmar