I'm having a really hard time making web queries on Mac. I'm trying to import the individual words from different news articles into different columns. So, ideally, each row would have all the words from all the articles on a certain day. Whenever I use this code: WEB 1 http://www.kcna.co.jp/item/2001/200106/news06/02.htm Selection=EntirePage Formatting=All PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False It only imports Back and Home Do you guys have any ideas? I don't know why its happening.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Web Query Mac

Thread starter KoreaUniv
Start date Nov 2, 2013
Tags

external data import mac web data import macro web queries

KoreaUniv

New Member

Nov 2, 2013

I'm having a really hard time making web queries on Mac. I'm trying to import the individual words from different news articles into different columns. So, ideally, each row would have all the words from all the articles on a certain day.

Whenever I use this code:

Code:

WEB
1
http://www.kcna.co.jp/item/2001/200106/news06/02.htm


Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False

It only imports Back and Home

Do you guys have any ideas? I don't know why its happening.