View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MichaelRobert MichaelRobert is offline
external usenet poster
 
Posts: 64
Default Import External data from a Website

The web table that I want to import is divided into a number of pages (1-12)
but only the first page is selectable (yellow arrow) in the 'New Web Query'
window.

I have tried setting up p2 in my browser, and then opening New Web Query,
but the URL relates to the first page, and I cannot move New Web query to the
second or subsequent pages.

Is there a way to import the subsequent pages?

Thanks.

Mike