Intro to Web Scraping with Excel VBA

  • Published on Dec 20, 2018
  • To download the exercise file and more information, visit the OfficeNewb blog:

Comments • 11

  • miles cruikshanks
    miles cruikshanks 26 days ago

    i have a page with a 6 columns by many rows table containing uniform sized pictures with text (ex. Bob Corp) and a price (ex. $2,000,000) in each picture. Any way to scrape this text and number out of the pictures?

  • njofang franck
    njofang franck Month ago

    Hey what if I wanted to click an (A) tag hyperlink inside a table of hyperlinks.
    Many thanks.
    Great tutorial. Perfect for the second phase of my education. 😎😎👌👌

  • Robert Sparkman
    Robert Sparkman Month ago

    I am subscribing because of this video!!

  • Sana Noor
    Sana Noor 2 months ago

    Could you please make a video on extracting reviews and rating for multiple keywords to search on a website using vba automation

  • Sana Noor
    Sana Noor 2 months ago

    Wow that's great video. Thank you

  • Azik D.
    Azik D. 2 months ago

    you're a good teacher. give us more of web scraping. can barely find any decent courses.

  • Missing No
    Missing No 2 months ago

    what if the site does not have Tables but divs ?

  • Md. Islam
    Md. Islam 4 months ago

    Thanks a lot for the video ,learned something very useful.
    I had one question regarding charts with let's say double headers, like the one in this link?

  • GSSS BIBIPUR School Patiala

    Dear Mr Kyle Pew,

    SUBJECT : Excel Query to search required record from large excel file in few clicks.

    I m ATTACHING EXCEL FILE For reference

    Sir i have one query ..i am Amandeep Singh and working as a school clerk. I am basic to intermediate level excel user.

    I am asked by many Students to find their name and complete record in an large excel file .
    I followed traditional way of Control +F shortcut Key which is time consuming . Right now I am finding the record of candidate with numerous click of keyboard

    I just want to know is there any well defined awesome excel query method like using Forms or using function or formula available to fetch the record of required candidate from large excel file.

    For example, I m fantasizaing about an excel form in which I have to select the named range of large excel fileand then only thing left is i have to fill the name of candidate,Fathers name of candidate and date of birth in a form or formula to fetch the record of required candidate I am lookin for.

    ..i m confused how to fetch the record of required candidate of my institute in few clicks.

    If any wayout is there pls share with me.
    I m looking forward to your response

    whats your email address where i have to share the excelfile

  • Adil Najmuddin
    Adil Najmuddin 5 months ago

    Very cool! Thanks for sharing. Is there a way to loop through all of the columns in the table as well?

  • ewillden
    ewillden 5 months ago

    Great video Mr. Pew! We here at American Airlines started using Udemy this year. Awesome stuff! Thx! ;-)