Excel VBA Introduction Part 48 - Web Scraping Across Multiple Pages

Share
Embed
  • Loading...
  • Published on:  Monday, November 14, 2016
  • PLEASE NOTE: The design of the website used in this video has changed since the video was recorded. This means that the code shown will no longer work for the website used. You can download both the original code and a revised, working version from this link https://www.wiseowl.co.uk/videos/excelvba/scraping-multiple-web-pages.htm

    If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

    You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html

    By Andrew Gould
    Download example files here https://www.wiseowl.co.uk/videos/excelvba/scraping-multiple-web-pages.htm

    https://www.wiseowl.co.uk - What's better than scraping one web page? Scraping lots of them with the same procedure, of couse! This video explains how to loop over multiple pages using Microsoft's HTML and XML object libraries. You'll learn about HTML tags and classes, the Document Object Model and how to loop over elements on a page.

    Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
  • Source: https://youtu.be/sGw6r5GVA5g
Loading...

Comment

  • Clifton Sett

     (Nov 15, 2016)

    I don’t know why the other Youtube videos covering Excel VBAlack the degree of knowledge or expertise that WiseOwl has displayed over andover again, but all I can say is WOW!!! Parts 46 to 48 of the Excel VBAIntroduction course are the epitome of excellence in presentation and execution oneducational material. I have watched all the WiseOwl videos repeatedly andevery time I learn something new and interesting and for that reason I say THANKYOU! I have spent hours looking for Youtube videos to enh...

  • Ogonna Anaekwe

     (Jun 18, 2017)

    Agree 100 per cent!

  • WiseOwlTutorials

     (Nov 15, 2016)

    Hi Clifton, many thanks for taking the time to write such lovely feedback, it's genuinely appreciated! I'm so happy to hear that you've found the videos so useful and that you think we're doing a good job. We'll do our best to maintain those high standards and hope that you'll find just as many useful tips in the videos still to come. Thank you again for the comments and for watching!

  • Excel y VBA - José Santos

     (Nov 23, 2016)

    Your Videos are amazing and the way you are teaching is really good.Will you prepare any example to use "POST" method?I love this kind of videos when we can use Excel with other different applications.I discovered Web Scraping with Excel time ago and the technique is the most usefull thing that I have seen in much timeThanks for the time that you dedicate to create the videos I know that it takes long...

  • WiseOwlTutorials

     (Nov 23, 2016)

    Thanks José, happy to hear that you've found the videos useful! I hadn't planned a video on using POST but I'll add it to the list. Thanks for watching!

  • vinay kumar

     (May 1, 2018)

    Thanks for all your videos it is really amazing and unparalleled. Would you please cover the topic of how to take screenshots and paste it in word document.And another video on Iframe handling

  • Juninawan Wawan

     (Feb 1, 2018)

    How to use XMLHTTPlogin to webInput pasword and username and clik buttonUsing XMLhttp

  • hadi reg

     (Dec 4, 2017)

    Indeed, the greatest teaching skills and coding knowledge so far! Great job folks, and many thanks for pushing this valuable material for free! RESPECT!

  • Piotr Lorenc

     (Apr 17, 2017)

    I don't leave comments usually but this time I couldn't resist: "Your videos are truly epic!!!" and Getting Data from Web playlist is simply a mastership. This is exactly what I was looking for recently. THANK YOU for all the knowledge you share in such accessible manner

  • WiseOwlTutorials

     (Apr 18, 2017)

    Thanks Piotr, happy to hear that you're finding the videos so useful and thank you for watching!

  • Don Bogdala

     (Nov 24, 2016)

    Another day, another lesson learned! Thanks so much! These tutorials are very addictive!

  • WiseOwlTutorials

     (Nov 24, 2016)

    You're welcome Don, glad you're still learning new things from the videos and thanks, as ever, for watching!

  • Laczor

     (Feb 17, 2017)

    Hi Andrew, I have been learning Excel VBA for more then 8 months and i wish if i have found your tutorials sooner! Your are explaining in such a detailed manner while giving us Tips, tricks best practices, Great work.!Also i was wondering if there is a great book, tutorial, article about the MSHTML /MSXML library in excel vba. I would like to learn the methods, objects of these libraries in structured way as you have been doing in your videos.Your response and daily work is greatly appreciated, Thank...

  • WiseOwlTutorials

     (Feb 17, 2017)

    Thank you so much for the kind comments! I'm happy to hear that you've found the videos useful and that you found us eventually!As to the MSHTML and MSXML documentation, I've never found a good single source for all of the information - most of what I've gathered comes from a variety of different source. If it helps, here's some official documentation from Microsoft - at least it gives you the list of Events, Properties and Methods https://msdn.microsoft.com/en-us/library/ms535874(v=vs.85).aspxI hope...

  • Forza Algiers

     (Nov 21, 2016)

    Great Video, great tutorial. Many thanks

  • WiseOwlTutorials

     (Nov 21, 2016)

    You're welcome! Thank you for watching!

  • Sasi Kumar

     (6 days ago)

    How to click on pop up box in internet explorer using vba