Thread
:
Import External data from a Website
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Import External data from a Website
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett