Excel Ninja In Training
New Member
- Joined
- May 6, 2011
- Messages
- 25
I'm new to Mr. Excel, but it looks like a great forum. Thanks in advance for your help.
Using Excel 2007, I've set up a data query pointing at the following Japanese newspaper website: http://www.asahi.com/international/list2.html
I selected full HTML formatting in the Web Query Options so that I could get all the hyperlinks to the individual stories, then selected the whole page as my target.
My problem is that out of the 60 story links on that page, only 11 (at this moment) are importing as proper hyperlinks.
Is there any way to tweak the way that Excel imports what's on the webpage, or is this the best that Excel can do?
Using Excel 2007, I've set up a data query pointing at the following Japanese newspaper website: http://www.asahi.com/international/list2.html
I selected full HTML formatting in the Web Query Options so that I could get all the hyperlinks to the individual stories, then selected the whole page as my target.
My problem is that out of the 60 story links on that page, only 11 (at this moment) are importing as proper hyperlinks.
Is there any way to tweak the way that Excel imports what's on the webpage, or is this the best that Excel can do?
