[VBA and Macros, Microsoft 2019] Reading data from website not working

Mahar92

New Member
Joined
Jan 25, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hello everybody!

I am not sure if this is the right place, so please be kind with me!

I am currently working with the "Microsoft Excel 2019 VBA and Macros" book. In the first part of Chapter 18 (Reading from and writing to the web) data is imported via Power Query
from the website wunderground.com. I am trying to replicate the technique, but it does not quite work.

Picture 1: Data I am getting when using the workbook provided with the book
Picture 2: Dataset found in the official workbook. Presumably, this is how the data imported from the website is supposed to look like.
Picture 3: After changing the URL (because I think it has changed since the book was released) from "URL;Local Weather Forecast, News and Conditions | Weather Underground" to North Canton, OH Weather History | Weather Underground, this is the data I am getting.

Is it my fault that this is not working or has the website changed over time date scrapping data is not possible anymore?



Ashampoo_Snap_Saturday, January 25, 2020_12h57m03s_001_.pngAshampoo_Snap_Saturday, January 25, 2020_12h57m41s_002_.pngAshampoo_Snap_Saturday, January 25, 2020_13h02m21s_003_.png

Kind regards,

Malte
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Mahar92

New Member
Joined
Jan 25, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Not sure how to edit my post, but these are the URLs (which don't show properly above):

Book URL: http://www.wunder ground.com/history/airport/KCAK//2019/6/27/DailyHistory.html
My Url: https://www.wunder ground.com/history/daily/KCAK/date/2019-6-27/DailyHistory.html
 

Forum statistics

Threads
1,144,628
Messages
5,725,376
Members
422,621
Latest member
dfrare

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top