Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Web Scraping Using Excel VBA
Highest Rated
Rating: 4.5 out of 5(62 ratings)
474 students

Web Scraping Using Excel VBA

Web Automation made easy with VBA
Highest Rated
Created byajay parmar
Last updated 7/2022
English

What you'll 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.
  • From debugging the issues to clicking on the links to scrape web page tables using different ways
  • How to launch a website but before launching the website, know the libraries we need it.
  • If website takes time to load how to keep code busy in events to avoid it going forward and then throw errors.
  • Work with attributes like name, id and what is their significance.
  • Work with important tags like a tags which helps in clicking on those links which has hyperlinks.
  • How to loop through all elements using collection loop or how to find out the specific element and then work with only that one
  • How to scrape table data into excel. How to target few or each and every table using loops.
  • Work with table , tr, th and td tags in one go or how to be specific about it.
  • How to do login on website using above knowledge and click on data calendar controls, fill the userform information on websites.
  • How to download files using API technique.
  • How to maximize webpage if needed
  • Projects also discussed for more confidence.
  • Learn the collection loops with the logics. Know difference between collection element and single element.

Course content

1 section • 17 lectures • 8h 1m total length

  • A Quick Demo- What are we covering?4:07

    Hi, I welcome you in my one of more series which is on how to connect with websites using internet explore using VBA.

    Just a brief idea as to what is going to be covered in this Series. Your problems and suggestions,whatever it may be ,will always be entertained and welcome.

    Course starts from basics and move to advance gradually. Wish you a happy web scraping.

  • Know the Basics first1:10:43

    Let us know what is web scraping and what are the points we should know about it in the beginning stage.

    Libraries used in Web-scraping using VBA and the object hierarchy system.

  • How to click Buttons - Handle A tag element36:51

    • We are learning now how to handle the website links. We call them "A" Tags in HTML language.

    • What is the procedure to click on website links.

    • Please note that file is available to download under lecture 11.

  • Handle hidden or disguised A tags - Great Learning for projects33:58

    • Fantastic ,Interesting. confusing situation here . What if we see the A tag links but still clicking does not work.

    • How to trouble shoot the A tags if they shown differently in website pages

  • How to handle a Class tag46:54

    • Exploring now Class tags after learning A tags in Html.

    • Learn the looping approach used in Class tags - its benefits and its usability

    • Click class tags directly by knowing their indexes. No loop then required.

  • Write Class tags (HTML) & Use API to maximize website page - Fun session14:45

    • Why dont we become HTML developer for few minutes and see why and how we use classes in website world.

    • Use of API to maximize the website pages.

  • How to handle ID Tags and a Project for you29:50

    • how to work with ID tags and Class tags together.

    • Can we put a value in search box using ID tag.

  • Solution to a Question asked in Lecutre614:46

    So, i am giving you a solution . We are creating a function which takes inputs from a sub routine and launches our web page as many times as we want.

  • Know your Input Tags & Button Tags33:32

    • how to use input tags in web page

    • why are they there? How it is created using html in notepad.

    • Putting the informatin into a text box using its input tag

    • what if you want to click on an icon which has a button tag and no other tag.So, how to click button tags in web pages.

  • Fill the form details using name Attribute23:34

    Let us explore about one of the attribute which you may see on web page . It is name attribute. How to take help from this attribute and fill in the forms on website.

  • Super Advance Project - How to Download the file from website34:14

    • This is a very powerful project we are discussing. Let us scrape the share market website.

    • Learn how to download the files from website if it does not download directly and gives you open and save as option in the form of weird pop up

    • Working with input tags, id attribute, loops and button loops.

    • Setting the variables in the right date format so it can go in the date pickers on web page easily and correctly.

    • Please note file downloaded in this lecture is same . I just added the one module for this project so don't get confused.

  • How to work with opened website page11:11

    You asked me if i have a website opened and there are other websites too then how can i work on one of it .

    This video will teach you to deal with existing opened web pages

  • How to scrape web tables54:29

    Take a deep dive into table html tags and see how we can import tables information using VBA

  • Project for you - How to get table data into excel - TD tags17:40
  • Project -How to tackle unexpected challenges while scraping table data into exce33:33
  • Project - Work with your choice of table when you have multiple ones on websites20:20

    if you want to export specific table data into excel then how should you do it. Amazing project for you

  • My Courses with links and Coupon Codes - 30 + Series waiting for you0:59

    Please see the below series information along-with links and join me in these world -class designed live classroom sessions. Bet. you will not be disappointed.


    · [Excel VBA Series]


    Excel VBA Introduction Series 1

    https://www.udemy.com/excel-vba-mis-analytics-training/?couponCode=EXCELVBASERIES1



    Excel VBA Loops and IF functions Sereis 2

    https://www.udemy.com/excel-vba-loops-if-mis-analytics/?couponCode=AJAYLOOP001



    Excel VBA Collection Loops and Workbook /Sheets handling Series 3

    https://www.udemy.com/excel-vba-collection-loops-mis-analytics-training/?couponCode=AJAYCOLLECTION


    Excel VBA Super Strong Arrays Series 4

    https://www.udemy.com/excel-vba-super-strong-arrays/?couponCode=AJAYARRAYS



    Excel VBA Functions Series 5

    https://www.udemy.com/excel-vba-functions-mis-analytics/?couponCode=AJAYFUNCTIONS



    Excel VBA File and Folder Handling Series 6

    https://www.udemy.com/learn-excel-vba-files-and-folder-handling/?couponCode=AJAYFILESFOLDER



    Excel VBA In depth UserForm Series 7

    https://www.udemy.com/excel-vba-in-depth-userforms/?couponCode=AJAYVBFORMS



    Excel VBA error handler and Message box /input Box Series 8

    https://www.udemy.com/error-handlers-with-message-input-box/?couponCode=AJAYERROR001



    Excel VBA Amazing and Phenomenal Events Series 9

    https://www.udemy.com/excel-vba-amazing-and-phenomenal-events/?couponCode=AJAYEVENTS001



    Excel VBA Awesome Pivots - Series 10

    https://www.udemy.com/excel-vba-awesome-pivots/?couponCode=AJAYPIVOT


    Excel VBA Charts Series 11

    https://www.udemy.com/excel-vba-charts-bonus-3-surprise-tests-for-you/?couponCode=AJAYVBACHARTS



    Excel VBA Connecting Outlook Series 12

    https://www.udemy.com/excel-vba-connecting-outlook-application/?couponCode=AJAYOUTLOOK001


    Excel VBA Connecting Powerpoint Series 13

    https://www.udemy.com/excel-vba-connecting-powerpoint-application-series-13/?couponCode=AJAYPOWERPOINT


    Excel VBA Connecting MS Access - Series 14

    https://www.udemy.com/excel-vba-connect-with-ms-access-series-14/?couponCode=AJAYCONNECTACCESS


    Excel & Access VBA Dashboard and Projects – Series 15

    https://www.udemy.com/advance-excel-access-dashboards-vba/?couponCode=AJAYAUTOMATION


    Web Scraping Using Excel VBA - Series 16

    https://www.udemy.com/draft/2540898/?couponCode=AJAYWEB



    · [MS Access VBA Series]


    Access VBA Introduction Series 1

    https://www.udemy.com/access-vba-introduction-series1/?couponCode=AJAYACCESSINTRO001


    Access VBA Arrays and Functions Series 2

    https://www.udemy.com/access-vba-arrays-and-functions-series-2/?couponCode=AJAYACCESSARRAY001



    Access Userform and SQL Series 3

    https://www.udemy.com/access-vba-series-3/?couponCode=AJAYACCESSFORMS001


    Access VBA File Handling and Error Handlers Series4

    https://www.udemy.com/access-vba-filefolder-handling-error-handler-s-series-4/?couponCode=AJAYFILES001


    Connection Strings ADODB and DAO Series 6

    https://www.udemy.com/connection-strings-ms-access-adodb-dao/?couponCode=AJAYCONNECTION


    Connect XL & Outlook Access VBA & Collection Loops Series 7

    https://www.udemy.com/connect-excel-using-access-vba-collection-loops-series-7/?couponCode=AJAYOUTLOOKEXCELAUTO




    · (Advance Excel Series)


    Excel MIS Analytics Advance Vlookup,Match and IF Series 1

    https://www.udemy.com/complete-vlookup-match-cell-referencing-if-discussion/?couponCode=AJAYLOOKUP


    Excel Index Error Handlers and Text Functions Series 2

    https://www.udemy.com/excel-mis-anaylytics-training-series2/?couponCode=AJAYSERIES2



    Excel MIS Analytics Indirect Count and Sum family functions Series 3

    https://www.udemy.com/excel-mis-analytics-training-series3/?couponCode=AJAYINDIRECT001


    Excel MIS Training Advance Filter and Conditional Formatting Series 4

    https://www.udemy.com/excel-mis-analytics-series4/?couponCode=AJAYFORMATFILTER


    Excel Date OFFSET Charts ACTIVE-X and FORM Controls Series 5

    https://www.udemy.com/excel-mis-analytics-date-time-offset-charts-series5/?couponCode=AJAYOFFSET001


    Advance Excel Arrays – Series6

    https://www.udemy.com/advance-excel-arrays-series-6/?couponCode=AJAYEXCELARRAYS






    · [MS Access (without VBA) Series]

    Introduction to Tables & Queries Series 1

    https://www.udemy.com/ms-access-table-and-queries-series-1/?couponCode=AJAYACCESSINTRO



    Sub Queries ,JOINS & Functions Series 2

    https://www.udemy.com/ms-access-sub-queries-joins-functions-series2/?couponCode=AJAYFUNCTIONS



    MS Access Forms Series 3

    https://www.udemy.com/ms-access-forms-series-3/?couponCode=AJAYFORMS


    MS Access Macros Series 4

    https://www.udemy.com/ms-access-macros-series-4/?couponCode=AJAYMACROS

Requirements

  • You should have a basic idea about VBA Like using variables. if conditions and Collection loops.

Description

  • 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

Who this course is for:

  • Students or working professionals who want to learn how we can control or automate our website day to day tasks.
  • Do you not wish to open the website on its own and then fill your form inputs.
  • how about downloading the files or clicking on menus on website.

Report abuse