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 • 21

  • German Duterte
    German Duterte 24 days ago

    Sir what if the website needs to input username and password ?

  • John Paul Francisco

    Awesome tutorail.. Thank you. What if the website have to enter password and username to input first?

  • John G
    John G Month ago

    You nailed it! You really have an inventive mind. This is learning by doing at its best . It is written that "A student is not better than the teacher, but the student who has been fully trained will be like the teacher"(Bible Luke 6:40). Thanks for the best stuff on earth. And, now I fill like I can code like my teacher--like you. "Great teachers are hard to find." How many more tricks you got? What's the best macro vba book for beginners that you might recommend me to buy?

  • John Jacob JinglehimerSchmidt

    Remember I when I was trying to do this like 9 years ago. Couldn't find anybody that had some clear tutorials. Talk about struggling to understand what I was doing. Now ..... I can find a plethora of vba tutorials out there. Where where ya'll around 2000?
    Nice vid.

  • Diego Vega
    Diego Vega 3 months ago

    excelent tutorial!

  • Rodrigo Lisboa Nascimento

    Many thanks. Great tutorial.

  • Rodrigo Lisboa Nascimento

    Many thanks. Great tutorial.

  • Rodrigo Lisboa Nascimento

    I love it so much! Thanks!!!

  • Sagar Shrivastava
    Sagar Shrivastava 3 months ago

    Sir, can you pls tell how to extract the href value of the next td, i wrote this code .Range("F" & i).Value = htmlELe.Children(5).href . But it is giving error. Can you pls tell me the correct line of code.

  • mangobrother
    mangobrother 3 months ago

    Great tutorial. You sir are a great teacher!

  • miles cruikshanks
    miles cruikshanks 4 months 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 5 months 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 5 months ago

    I am subscribing because of this video!!

  • Sana Noor
    Sana Noor 5 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 5 months ago

    Wow that's great video. Thank you

  • Azik D.
    Azik D. 6 months ago

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

  • Missing No
    Missing No 6 months ago

    what if the site does not have Tables but divs ?

  • Md. Islam
    Md. Islam 8 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 8 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 9 months ago

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