Thread
:
combining multiple pages from Web automatically
View Single Post
#
2
Mark
Posts: n/a
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
.
Reply With Quote