EXCEL VBA WEB SCRAPING- Basic to Advance

Description

• Web Automation via Internet Explorer – No more manual stuff. It can be done using automation now.
• Learn about Web Scraping using VBA (Internet explorer)
• Basic to Advance Level Course for all
• How to work with <A> tags
• How to work with <Class> Tags
• 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