mercredi 23 décembre 2015

Webpage query and import data to excel

I am trying to extract specific data from several web pages under http://ift.tt/1JumnSJ

I am interested in pulling the title of the article, the last Updated on field, the KB views and the ratings (four fields in total)

The default number of pages for all KB articles is 40 and a basic web query in Excel that I tried didn't work.

I also reviewed Microsoft Excel 2010 Web Query Macro: Pulling Multiple Pages From One but it did not work.

Any help would be great!




Aucun commentaire:

Enregistrer un commentaire