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?
Kind regards,
Malte
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?
Kind regards,
Malte