I'm trying to create a spreadsheet using the Import External Data - Web
Query tool.. The website has a table on it, but it only displays 50
lines of data.. and has a next button.. the URL have an indicator in it
such as http://www.thewebsite.com/datasearch...ge=1.restofurl. (obviously
just an example..) so. I go to page one, and export that table.. then,
I have to go to page 2.
Is there a script? or automated query that I can do that will just go
and grab all the pages (there will be about 75 pages).. instead of doing
it manually?
I tried searching the forum, but could not find the answer... note.. I
have no knowledge of programming.
--
Rob

Hi,
Try this but I haven't yet ... just a thought on tthe
go ...

Record Macro ... open the web page in excel then click the
next button .... Stop macro and see the result. you could
modify it to include all the pages.

If you want, you can send that result to me and maybe I
could modify it but no guarantees.

http://www.geocities.com/excelmarksway



regards
Mark


-----Original Message-----
I'm trying to create a spreadsheet using the Import
External Data - Web
Query tool.. The website has a table on it, but it only
displays 50
lines of data.. and has a next button.. the URL have an
indicator in it
such as www.thewebsite.com/datasearch.asp?
page=1.restofurl. (obviously
just an example..) so. I go to page one, and export
that table.. then,
I have to go to page 2.
Is there a script? or automated query that I can do that
will just go
and grab all the pages (there will be about 75 pages)..
instead of doing
it manually?
I tried searching the forum, but could not find the
answer... note.. I
have no knowledge of programming.
--
Rob
.