Importing text from webpage into excel and then loop?
 

I am trying to get external text (search results) from a website that has
more then one page (unlimited number) and import that text into excel.

If i use the get external data query, i have no troubles setting it up for
the one page, BUT i would like a macro that then recognises the "next"
button on the activate webpage and then runs the query again, and then loop
this.

Can anyone help me please.

cheers