View Single Post
  #5   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

Thanks, Don. I'll contact them.

Have you been successful in the past in importing the full table when it is
presented in multiple sheets like this? I'd like to know if I am dealing with
a site-specific problem or a general problem with this type of data
presentation.

Mike

"Don Guillett" wrote:


Probably. Give the url and describe the pages you want and/or the steps you
take to get there.
Often you can record a macro while fetching and then modify the url to get
the other pages.??
This is the sort of thing I often do for clients.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MichaelRobert" wrote in message
...
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