combining multiple pages from Web automatically

[Terri and Rob]

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.

 

[Mark]

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
(e-mail address removed)


regards
Mark