gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
- Mobile
I would like to set up a workbook so that I can retrieve the front pages of various news websites, and am curious what the quickest way to do that would be, if it is possible.
As a pilot run, I have been using the Data tab to try and retrieve the headlines from www.cnn.com, and have not had ideal results so far. Using the From Web command will load the website, but I don't know what to do next, since it just inserts one row of nothing. Here's some screenshots:
This is the tab I've been using. I have entered it as either www.cnn.com or https://www.cnn.com
There is also an Advanced Tab, but I'm not sure if it is necessary.
This is what comes up next. Nothing is show here, so I click on the Web View portion.
Web view shows the actual website, but has a warning about Internet Explorer. I'm not sure where to change this to Edge or Chrome.
Anyway, I have tried click either Load or Transform Data, but either way I end up with this result:
Happy to clarify if any additional information is needed. Thanks!
As a pilot run, I have been using the Data tab to try and retrieve the headlines from www.cnn.com, and have not had ideal results so far. Using the From Web command will load the website, but I don't know what to do next, since it just inserts one row of nothing. Here's some screenshots:
This is the tab I've been using. I have entered it as either www.cnn.com or https://www.cnn.com
There is also an Advanced Tab, but I'm not sure if it is necessary.
This is what comes up next. Nothing is show here, so I click on the Web View portion.
Web view shows the actual website, but has a warning about Internet Explorer. I'm not sure where to change this to Edge or Chrome.
Anyway, I have tried click either Load or Transform Data, but either way I end up with this result:
Happy to clarify if any additional information is needed. Thanks!
