My Online Training Hub
Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
I've written about web scraping before using VBA, but never about interacting with the website to do things like filling in forms. We had a forum question asking how to do exactly that so I tried using the same approach as I had previously with the HTML Object Library, but when it came to grabbing …
Previously we looked at scraping data from the web by example, where the website paginated the data. That is, it spread the results over multiple pages. This week I’m going to show you how you can automatically scrape data from multiple web pages with Power Query using a custom function. This approach works with URLs …
Getting data from the web is possible with Power Query in both Excel and Power BI. However, Excel is a little behind in Power Query features, therefore in this post I’m going to show you a new feature available in Power BI Desktop using Power Query to get data from the web by example. In …
My last post looked at web scraping using VBA, where I loaded a single page and extracted content. In this post I'm looking at loading multiple pages from a site and getting the content I want from each page. Related Topics Web Scraping – Filling in Forms Web Scraping With VBA Let's say I want …
We can use VBA to retrieve webpages and comb through those pages for data we want. This is known as web scraping. This post will look at getting data from a single web page. I've written another post that deals with getting data from multiple web pages. Related Topics Web Scraping – Filling in Forms …
